Difference between revisions of "Amazon Redshift: show permissions"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
u.usename, | u.usename, | ||
s.schemaname, | s.schemaname, | ||
| − | [[has_schema_privilege]](u.usename,s.schemaname,'create') AS user_has_select_permission, | + | [[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 | + | has_schema_privilege(u.usename,s.schemaname,'[[usage]]') AS user_has_usage_permission |
FROM | FROM | ||
[[pg_user]] u | [[pg_user]] u | ||
Revision as of 10:03, 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
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:
