Difference between revisions of "HAS TABLE PRIVILEGE"
Jump to navigation
Jump to search
| (5 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 | ||
| Line 12: | Line 11: | ||
* <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]] | ||
| + | * <code>[[HAS_SCHEMA_PRIVILEGE]]</code> | ||
| + | * <code>[[HAS_DATABASE_PRIVILEGE]]</code> | ||
== See also == | == See also == | ||
| + | * {{GRANT}} | ||
* {{Amazon Redshift}} | * {{Amazon Redshift}} | ||
[[Category: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:
