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

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

  




 

 

Databases - Practical PostgreSQL
Previous Page Home Next Page

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
Databases - Practical PostgreSQL
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire