|
 |
|
| |
NameREVOKE -- 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
|
|
|
