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_PRIVILEGEHAS_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:
