Practical PostgreSQL
PrevNext

REVOKE

Name

REVOKE  --  Revokes access privileges from a user, a group, or all users.

Synopsis

REVOKE privilege [, ...]
    ON object [, ...]
    FROM { PUBLIC | GROUP groupname | username }

Inputs

privilege

Use this parameter to state the privilege to revoke. Use 'SELECT,' 'INSERT,' 'UPDATE,' or 'DELETE' to revoke the privilege to use those commands. Use RULE to revoke the privilege to create rules on a table. Use ALL to remove all privileges.

object

Use this parameter to supply the name of an object you wish to revoke privileges to. This object can be a table, view, or sequence.

group

Use this parameter to provide the name of a group to revoke privileges from.

username

Use this parameter to provide the name of a user account to revoke privileges from.

PUBLIC

Revoke the specified privileges from all user accounts.

Results

CHANGE

This message is displayed if the privileges are successfully revoked.

ERROR

This message is displayed if the target object is not available or it is impossible to revoke privileges from the specified user or group.

Description

Use REVOKE to remove privileges to an object that you are the owner of. You can revoke privileges to a specific user account, a group, or all users by specifying the PUBLIC keyword.

Examples

The following example will revoke priviliges from a temporary employee on the customer table. 

booktown=# REVOKE INSERT ON customer FROM temp;

PrevHomeNext
RESETUpROLLBACK