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