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
, orDELETE
to revoke the privilege to use the corresponding command. UseRULE
to revoke the privilege to create rules on a table. UseALL
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
Get Practical PostgreSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.