Difference between revisions of "Amazon Redshift: show permissions"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
== Related == | == Related == | ||
* <code>[[has_table_privilege]]</code> | * <code>[[has_table_privilege]]</code> | ||
| + | * [[View GRANTs on Redshift]] | ||
== See also == | == See also == | ||
Revision as of 09:50, 10 December 2021
SELECT
u.usename,
s.schemaname,
has_schema_privilege(u.usename,s.schemaname,'create') AS user_has_select_permission,
has_schema_privilege(u.usename,s.schemaname,'usage') AS user_has_usage_permission
FROM
pg_user u
CROSS JOIN
(SELECT DISTINCT schemaname FROM pg_tables) s
WHERE
u.usename = 'myUserName'
AND s.schemaname = 'mySchemaName'
;
Related
See also
Advertising:
