GRANT

Attention

This page documents an earlier version. Go to the latest (v2.0)version.

Synopsis

Use the GRANT statement to allow access privileges.

grant ::= GRANT privileges ON privilege_target TO name [ , ... ] 
          [ WITH GRANT OPTION ]

Not all GRANT options are supported yet in YSQL, but the following GRANT option is supported.

GRANT ALL ON DATABASE name TO name;

For the list of possible privileges or privilege_target settings, see REVOKE in the PostgreSQL documentation.

Grant privileges on a database object or grant a membership in a role.

Specify the privileges.

Grant all of the available privileges.

Specify the name of the role.

Specify that the recipient of the privileges can in turn grant them to others. Grant options cannot be granted to PUBLIC.

Grant John all privileges on the postgres database.

postgres=# GRANT ALL ON DATABASE postgres TO John;