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.
- PostgreSQL 14
GRANTED BYclause added (commit 6aaaa76b)
- PostgreSQL 8.4
TRUNCATEprivilege for tables added (commit a0b76dc6)
- PostgreSQL 8.2
- PostgreSQL 8.0
GRANT ... ON TABLESPACEsyntax added (commit 2467394e)
- PostgreSQL 7.4
WITH GRANT OPTIONsyntax added (commit ef742251)
- PostgreSQL 7.3
- PostgreSQL 7.2
GRANTcan change permissions for multiple users in a single invocation (commit 7ceed2a9)
REVOKE, ALTER DEFAULT PRIVILEGES