GRANT

A utility command for providing a user with privileges

GRANT is a utility command for providing a user with privileges on database objects and databases.

GRANT has always been present in PostgreSQL.

Change history

Work-in-progress

Examples

Basic usage example for GRANT:

postgres=# GRANT pg_read_all_stats TO foo;
GRANT ROLE
  • PostgreSQL documentation: GRANT

Categories

Users and roles, Utility command

See also

REVOKE, ALTER DEFAULT PRIVILEGES