17.20. GRANT

Synopsis

GRANT ( privilege [, ...] | ( ALL PRIVILEGES ) )
ON [ TABLE ] table_name TO ( grantee | PUBLIC )
[ WITH GRANT OPTION ]

Usage of the term grantee denotes both users and roles.

Grants the specified privileges to the specified grantee.

Specifying ALL PRIVILEGES grants DELETE, INSERT and SELECT privileges.

Specifying PUBLIC grants privileges to the PUBLIC role and hence to all users.

The optional WITH GRANT OPTION clause allows the grantee to grant these same privileges to others.

For GRANT statement to succeed, the user executing it should possess the specified privileges as well as the GRANT OPTION for those privileges.

Note

Ensure that authentication has been enabled before running any of the authorization commands such as GRANT, REVOKE or SHOW GRANTS.

Grant INSERT and SELECT privileges on the table orders to user alice:

GRANT INSERT, SELECT ON orders TO alice;

Grant SELECT privilege on the table nation to user alice, additionally allowing alice to grant SELECT privilege to others:

GRANT SELECT ON nation TO alice WITH GRANT OPTION;

Grant SELECT privilege on the table orders to everyone:

GRANT SELECT ON orders TO PUBLIC;

Some connectors have no support for GRANT. See connector documentation for more details.