Skip to content

Instantly share code, notes, and snippets.

@kerbelp

kerbelp/redshift_v_users_groups.sql

Created January 3, 2017 22:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kerbelp/67af23d5abc5700788fb08b613b71a68 to your computer and use it in GitHub Desktop.
Save kerbelp/67af23d5abc5700788fb08b613b71a68 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
redshift_v_users_groups.sql
CREATE OR REPLACE VIEW admin.v_users_groups
AS
SELECT pg_group.groname as group_name,
pg_user.usename as user_name,
pg_user.usesuper as is_superuser
FROM pg_group,
pg_user
WHERE pg_user.usesysid = ANY (pg_group.grolist);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment