select * from information_schema.role_table_grants where grantee='YOUR_USER';
ERROR: permission denied for
See also[edit]
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
- SELECT, GRANT SELECT ON