Skip to content

Instantly share code, notes, and snippets.

@bweigel

bweigel/gist:a0939d1d0d0e193f9163c56c7d9f089f

Created April 20, 2018 12:16
Show Gist options
  • Save bweigel/a0939d1d0d0e193f9163c56c7d9f089f to your computer and use it in GitHub Desktop.
Save bweigel/a0939d1d0d0e193f9163c56c7d9f089f to your computer and use it in GitHub Desktop.
Download ZIP
[RedShift] get userpermissions for schemas
Raw
gistfile1.sql
SELECT *
FROM
(
SELECT
schemaname
,usename
,HAS_SCHEMA_PRIVILEGE(usrs.usename, schemaname, 'create') AS _create
,HAS_SCHEMA_PRIVILEGE(usrs.usename, schemaname, 'usage') AS _usage
FROM
(
SELECT DISTINCT(schemaname) FROM pg_tables
WHERE schemaname not in ('pg_internal')
) AS objs
,(SELECT * FROM pg_user) AS usrs
ORDER BY schemaname
)
WHERE schemaname='schema'
and usename = 'user';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment