Revoking privileges
We can revoke priviliges on tables and functions/procedures using REVOKE. Let’s see a couple of example to better understand it.
We can revoke privileges for common DML statements (select, insert, update and delete). We use sentences like this:
REVOKE select, insert ON mytable FROM myuser;
We can also revoke privileges for some DDL statements. If we want to let an user modify the structure of a table, we use a sentence like this:
REVOKE alter ON mytable FROM myuser;
Another use of the REVOKE sentence is to remove permission to execute procedures and functions.
REVOKE execute ON myfunction FROM myuser;