Difference between revisions of "Amazon Redshift: show permissions"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
AND s.schemaname = 'mySchemaName' | AND s.schemaname = 'mySchemaName' | ||
; | ; | ||
| + | |||
| + | == Related == | ||
| + | * <code>[[has_table_privilege]]</code> | ||
== See also == | == See also == | ||
Revision as of 11:11, 12 November 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:
