Provided by: manpages-zh_1.5.2-1_all bug

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>