Difference between revisions of "HAS TABLE PRIVILEGE"
Jump to navigation
Jump to search
(10 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | |||
https://docs.aws.amazon.com/redshift/latest/dg/r_HAS_TABLE_PRIVILEGE.html | 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) | ||
− | {{Amazon Redshift}} | + | == Related == |
+ | * <code>[[GRANT USAGE]] ON { DATABASE shared_database_name [, ...] | SCHEMA shared_schema} TO { username | GROUP group_name | PUBLIC } [, ...]</code> | ||
+ | * [[Amazon Redshift: show permissions]] | ||
+ | * [[View GRANTs on Redshift]] | ||
+ | * <code>[[HAS_SCHEMA_PRIVILEGE]]</code> | ||
+ | * <code>[[HAS_DATABASE_PRIVILEGE]]</code> | ||
+ | |||
+ | == See also == | ||
+ | * {{GRANT}} | ||
+ | * {{Amazon Redshift}} | ||
+ | |||
+ | [[Category:Redshift]] |
Latest revision as of 16:04, 13 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[edit]
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[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
- Amazon Redshift,
aws redshift
, Amazon Redshift query editor, GRANT, AQUA,has schema privilege
, WLM, Amazon Redshift Spectrum, metrics, VACUUM, SET
Advertising: