REVOKE(l) SQL - Language Statements (2002-11-22) REVOKE(l)
NAME
REVOKE - remove access privileges
SYNOPSIS
REVOKE { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }
[,...] | ALL [ PRIVILEGES ] }
ON [ TABLE ] tablename [, ...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
REVOKE { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
ON DATABASE dbname [, ...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
REVOKE { EXECUTE | ALL [ PRIVILEGES ] }
ON FUNCTION funcname ([type, ...]) [, ...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
REVOKE { USAGE | ALL [ PRIVILEGES ] }
ON LANGUAGE langname [, ...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
REVOKE { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
ON SCHEMA schemaname [, ...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
DESCRIPTION
REVOKE allows the creator of an object to revoke previously
granted permissions from one or more users or groups of
users. The key word PUBLIC refers to the implicitly defined
group of all users.
Note that any particular user will have the sum of
privileges granted directly to him, privileges granted to
any group he is presently a member of, and privileges
granted to PUBLIC. Thus, for example, revoking SELECT
privilege from PUBLIC does not necessarily mean that all
users have lost SELECT privilege on the object: those who
have it granted directly or via a group will still have it.
See the description of the GRANT [grant(l)] command for the
meaning of the privilege types.
NOTES
Use psql(1)'s \z command to display the privileges granted
on existing objects. See also GRANT [grant(l)] for
information about the format.
EXAMPLES
Revoke insert privilege for the public on table films:
REVOKE INSERT ON films FROM PUBLIC;
Page 1 (printed 3/24/03)
REVOKE(l) SQL - Language Statements (2002-11-22) REVOKE(l)
Revoke all privileges from user manuel on view kinds:
REVOKE ALL PRIVILEGES ON kinds FROM manuel;
COMPATIBILITY
SQL92
The compatibility notes of the GRANT [grant(l)] command
apply analogously to REVOKE. The syntax summary is:
REVOKE [ GRANT OPTION FOR ] { SELECT | INSERT | UPDATE | DELETE | REFERENCES }
ON object [ ( column [, ...] ) ]
FROM { PUBLIC | username [, ...] }
{ RESTRICT | CASCADE }
If user1 gives a privilege WITH GRANT OPTION to user2, and
user2 gives it to user3 then user1 can revoke this privilege
in cascade using the CASCADE keyword. If user1 gives a
privilege WITH GRANT OPTION to user2, and user2 gives it to
user3, then if user1 tries to revoke this privilege it fails
if he specifies the RESTRICT keyword.
SEE ALSO
GRANT [grant(l)]
Page 2 (printed 3/24/03)