April 2015
Intermediate to advanced
504 pages
11h 41m
English
This recipe answers the question, "How do I make sure that user X cannot access table Y?"
The current user must either be a superuser, the owner of the table, or a user with a GRANT option for the table.
Also, you can't revoke rights from a user who is a superuser.
To revoke all rights on the table1 table from the user2 user, you must run the following SQL command:
REVOKE ALL ON table1 FROM user2;
However, if user2 had been granted another role that gives them some rights on table1, say role3, this command is not enough; you must also choose one of the following options:
role3 from user2table1 from role3Both choices ...