Revoking user access to a table
The current user must either be a superuser, the owner of the table, or a user with a
GRANT option for the table.
Also, bear in mind that you can't revoke rights from a user who is a superuser.
How to do it…
REVOKE ALL ON table1 FROM user2;
user2 has been granted another role that gives them some rights on
role3—this command is not enough; you must also choose one of the following options:
- Fix the user—that is, revoke
- Fix the role—that is, revoke privileges on
Both choices are imperfect because of their side effects. The former will revoke all of the privileges associated with
role3, not just the privileges concerning...