Difference between revisions of "HAS TABLE PRIVILEGE"
Jump to navigation
Jump to search
Line 12: | Line 12: | ||
* <code>[[GRANT USAGE]] ON { DATABASE shared_database_name [, ...] | SCHEMA shared_schema} TO { username | GROUP group_name | PUBLIC } [, ...]</code> | * <code>[[GRANT USAGE]] ON { DATABASE shared_database_name [, ...] | SCHEMA shared_schema} TO { username | GROUP group_name | PUBLIC } [, ...]</code> | ||
* [[Amazon Redshift: show permissions]] | * [[Amazon Redshift: show permissions]] | ||
+ | * [[View GRANTs on Redshift]] | ||
== See also == | == See also == |
Revision as of 09:49, 10 December 2021
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
See also
Advertising: