Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

REVOKE

Name

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

 
 
  Published courtesy of O'Reilly Design by Interspire