REVOKE -- Revokes access privileges from a user, a group, or all users.
Synopsis
REVOKE privilege [, ...]
ON object [, ...]
FROM { PUBLIC | GROUP groupname | username }
Parameters
privilege
A privilege to revoke. Specify SELECT, INSERT, UPDATE, or DELETE to revoke the privilege to use the corresponding command. Use RULE to revoke the privilege to create rules on a table. Use ALL to remove all privileges on a table or other object.
object
The name of the object from which you wish to revoke privileges. This object can be a table, view, or sequence.
group
The name of a group from which to revoke privileges.
user
The name of a PostgreSQL user from which to revoke privileges.
PUBLIC
The keyword that revokes specified privileges from all PostgreSQL users.
Results
CHANGE
The message returned when privileges are successfully revoked.
ERROR: Relation 'object' does not exist
The error returned if object does not exist in the connected database.
ERROR: aclparse: non-existent user "user"
The error returned if user does not exist.
ERROR: non-existent group "group"
The error returned if group does not exist.
Description
Use REVOKE to remove privileges to an object of which you are the owner. You can revoke privileges from a specific user, from a group, or from all users (by specifying the PUBLIC keyword).
Example
The following example revokes INSERT privileges on the books table from a user guest:
booktown=# REVOKE INSERT ON guest FROM books;
CHANGE