GRANT

• PostgreSQL Documentation: https://www.postgresql.org/docs/current/sql-grant.html

Examples

• GRANT ALL PRIVILEGES ON DATABASE YOUR_DB_NAME TO YOUR_USERNAME;

SELECT
INSERT
UPDATE
DELETE
TRUNCATE
REFERENCES
TRIGGER
CREATE
CONNECT
TEMPORARY
EXECUTE
USAGE

GRANT USAGE

GRANT USAGE ON ALL SEQUENCES IN SCHEMA your_schema TO mygrp; 

GRANT your_defined_role TO your_username;
GRANT ROLE

SELECT * FROM your_table_name;
ERROR: permission denied for table your_table_name

GRANT SELECT ON mytable TO xxx

• List roles: \du or SELECT * FROM pg_roles;

Amazon Redshift system information functions:

• HAS_TABLE_PRIVILEGE
• HAS_SCHEMA_PRIVILEGE
• HAS_ASSUMEROLE_PRIVILEGE
• HAS_DATABASE_PRIVILEGE

• View GRANTs on Redshift: (HAS_TABLE_PRIVILEGE)
• Amazon Redshift: show permissions: (has_schema_privilege)

Related terms

• Amazon Redshift: GRANT
• \dn+
• \ddp
• CREATE ROLE
• Connect to a database
• Show databases
• Create database
• Delete database
• Create user
• List users
• List databases
• List tables: show tables
• GRANT

See also

• GRANT, \ddp, GRANT USAGE, GRANT ALL PRIVILEGES, GRANT SELECT, View GRANTs on Redshift, has_table_privilege, has_schema_privilege, HAS_DATABASE_PRIVILEGE, SCHEMA, Privileges, GRANT EXECUTE

https://stackoverflow.com/a/10353730

https://dba.stackexchange.com/a/184339