Revokes access privileges from a user, a group, or all users.
REVOKE privilege [, ...] ON object [, ...] FROM { PUBLIC | GROUP groupname | username }
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.
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.
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).