Provided by:
manpages-zh_1.5.2-1_all 
NAME
REVOKE -
SYNOPSIS
REVOKE [ GRANT OPTION FOR ]
{ { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }
[,...] | ALL [ PRIVILEGES ] }
ON [ TABLE ] tablename [, ...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
ON DATABASE dbname [, ...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ EXECUTE | ALL [ PRIVILEGES ] }
ON FUNCTION funcname ([type, ...]) [, ...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ USAGE | ALL [ PRIVILEGES ] }
ON LANGUAGE langname [, ...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
{ { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
ON SCHEMA schemaname [, ...]
FROM { username | GROUP groupname | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
DESCRIPTION
REVOKE PUBLIC
GRANT [grant(7)]
// PUBLIC PUBLIC SELECT SELECT
GRANT OPTION FOR
CASCADE REVOKE
NOTES
psql(1) \z GRANT [grant(7)]
A B B C A C A B CASCADE C
GRANT REVOKE CASCADE
EXAMPLES
films
REVOKE INSERT ON films FROM PUBLIC;
manuel kinds
REVOKE ALL PRIVILEGES ON kinds FROM manuel;
COMPATIBILITY
GRANT [grant(7)] REVOKE
REVOKE [ GRANT OPTION FOR ] privileges
ON object [ ( column [, ...] ) ]
FROM { PUBLIC | username [, ...] }
{ RESTRICT | CASCADE }
RESTRICT CASCADE PostgreSQL RESTRICT
SEE ALSO
GRANT [grant(7)]
Postgresql <laser@pgsqldb.org>