REVOKE(7)                        SQL Commands                        REVOKE(7)

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>

<?>
       <?><?><?><?><?><?><?><?><?> man <?><?><?><?><?><?><?><?>
       <?><?> man <?><?><?><?><?><?>https://github.com/man-pages-zh/manpages-
       zh

SQL - Language Statements         2003-11-02                         REVOKE(7)