GRANT(7)                         SQL Commands                         GRANT(7)

NAME
       GRANT - <?><?><?><?><?><?>


SYNOPSIS
       GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }
           [,...] | ALL [ PRIVILEGES ] }
           ON [ TABLE ] tablename [, ...]
           TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ]

       GRANT { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
           ON DATABASE dbname [, ...]
           TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ]

       GRANT { EXECUTE | ALL [ PRIVILEGES ] }
           ON FUNCTION funcname ([type, ...]) [, ...]
           TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ]

       GRANT { USAGE | ALL [ PRIVILEGES ] }
           ON LANGUAGE langname [, ...]
           TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ]

       GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
           ON SCHEMA schemaname [, ...]
           TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ]


DESCRIPTION <?><?>
       GRANT
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

        <?><?> PUBLIC <?><?><?><?><?><?><?><?><?><?><?><?>,
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?>PUBLIC
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>/<?><?><?><?><?><?><?><?>/<?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?> PUBLIC <?><?><?><?><?><?><?>

        <?><?><?><?><?> WITH GRANT
       OPTION<?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       PUBLIC<?>

        <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

        <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?> PUBLIC
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       TEMP <?><?><?><?><?><?><?><?><?><?>EXECUTE <?><?><?><?><?><?><?> <?><?>
       USAGE <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       REVOKE<?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

        <?><?><?><?><?><?><?>

       SELECT
               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?> SELECT
              [select(7)] <?><?><?><?><?><?><?><?><?> COPY [copy(7)] TO
              <?><?><?> <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
              currval <?><?><?>

       INSERT
               <?><?><?><?><?><?><?> INSERT [insert(7)] <?><?><?><?><?>
              <?><?><?><?><?><?> COPY [copy(7)] FROM<?>

       UPDATE
               <?><?><?><?><?><?><?><?><?><?><?><?><?> UPDATE [update(7)] <?>
              SELECT ... FOR UPDATE <?><?><?><?><?><?><?> <?><?><?> SELECT
              <?><?><?><?><?><?><?><?><?> <?><?><?><?><?><?><?><?>nextval <?>
              setval<?>

       DELETE
               <?><?><?><?><?><?><?><?> DELETE [delete(7)] <?><?>

       RULE
               <?><?><?><?><?>/<?><?><?><?><?><?><?><?><?><?><?> CREATE RULE
              [create_rule(7)] <?><?><?><?>

       REFERENCES
               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       TRIGGER
               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?> CREATE TRIGGER
              [create_trigger(7)] <?><?><?><?>

       CREATE
               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
              <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
              <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       TEMPORARY

       TEMP
               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       EXECUTE
               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
              <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
              <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       USAGE
               <?><?><?><?><?><?><?>
              <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
              <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
              <?><?><?><?><?><?><?><?><?><?><?><?><?>"<?><?>"<?><?><?><?><?><?><?>

       ALL PRIVILEGES
               <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?> PRIVILEGES
              <?><?><?><?> PostgreSQL <?><?><?><?><?><?> <?><?><?><?><?> SQL
              <?><?><?><?><?><?><?><?><?>

        <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

NOTES <?><?>
       REVOKE [revoke(7)] <?><?><?><?><?><?><?><?><?><?><?>

        <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?> Unix
       <?><?><?> root  <?><?><?><?><?> root
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       If a superuser chooses to issue a GRANT or REVOKE command, the command
       is performed as though it were issued by the owner of the affected
       object. In particular, privileges granted via such a command will
       appear to have been granted by the object owner.

        <?><?><?><?><?> PostgreSQL <?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

        <?><?> psql(1) <?> \z
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       => \z mytable

               Access privileges for database "lusitania"
        Schema |  Table  |           Access privileges
       --------+---------+---------------------------------------
        public | mytable | {=r/postgres,miriam=arwdRxt/postgres,"group todos=arw/postgres"}
       (1 row)

       \z <?><?><?><?><?><?><?><?><?><?>

                     =xxxx -- <?><?> PUBLIC <?><?><?>
                uname=xxxx -- <?><?><?><?><?><?><?><?><?>
          group gname=xxxx -- <?><?><?><?><?><?><?><?>

                         r -- SELECT ("<?>")
                         w -- UPDATE ("<?>")
                         a -- INSERT ("<?><?>")
                         d -- DELETE
                         R -- RULE
                         x -- REFERENCES
                         t -- TRIGGER
                         X -- EXECUTE
                         U -- USAGE
                         C -- CREATE
                         T -- TEMPORARY
                   arwdRxt -- ALL PRIVILEGES (for tables)
                         * -- <?><?><?><?><?><?><?><?><?><?>

                     /yyyy -- <?><?><?><?><?><?><?><?><?>

        <?><?> miriam <?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?>

       GRANT SELECT ON mytable TO PUBLIC;
       GRANT SELECT, UPDATE, INSERT ON mytable TO GROUP todos;


        <?><?><?><?><?><?><?><?><?><?> "Access privileges" <?><?><?><?><?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       NULL<?><?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       PUBLIC  <?><?><?><?> <?><?><?><?><?><?> GRANT <?><?> REVOKE
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?> {=,miriam=arwdRxt}<?>
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

EXAMPLES <?><?>
        <?><?> films <?><?><?><?><?><?><?><?><?><?><?><?>

       GRANT INSERT ON films TO PUBLIC;


        <?><?><?><?>manuel<?><?><?>kinds<?><?><?><?><?><?>

       GRANT ALL PRIVILEGES ON kinds TO manuel;


COMPATIBILITY <?><?><?>
        <?><?> SQL <?><?><?><?> ALL PRIVILEGES <?><?> PRIVILEGES
       <?><?><?><?><?><?><?><?>SQL
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       SQL <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       GRANT privileges
           ON table [ ( column [, ...] ) ] [, ...]
           TO { PUBLIC | username [, ...] } [ WITH GRANT OPTION ]


       SQL <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?> USAGE
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>

       RULE
       <?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?><?>
       PostgreSQL <?><?><?>

SEE ALSO <?><?>
       REVOKE [revoke(7)]

<?><?>
       Postgresql <?><?><?><?> <?><?><?> <laser@pgsqldb.org>

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

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