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 } [, ...]

See also

• Amazon Redshift, aws redshift, Amazon Redshift query editor, AQUA, WLM, Amazon Redshift Spectrum, metrics, VACUUM, Amazon RedShift Management Guide, Datashare