HAS TABLE PRIVILEGE

https://docs.aws.amazon.com/redshift/latest/dg/r_HAS_TABLE_PRIVILEGE.html

select has_table_privilege('YourGuestUser', 'YourTable', 'select');

has_table_privilege
---------------------
false
(1 row)

Related

• GRANT USAGE ON { DATABASE shared_database_name [, ...] | SCHEMA shared_schema} TO { username | GROUP group_name | PUBLIC } [, ...]
• Amazon Redshift: show permissions
• View GRANTs on Redshift
• HAS_SCHEMA_PRIVILEGE
• HAS_DATABASE_PRIVILEGE

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
• Amazon Redshift, Redshift Serverless, aws redshift, Amazon Redshift query editor, AQUA, WLM, Amazon Redshift Spectrum, metrics, VACUUM, Amazon RedShift Management Guide, Datashare, SVV