Skip to content

Instantly share code, notes, and snippets.

@altitdb
Created April 17, 2018 16:10
Show Gist options
  • Save altitdb/f6709d09f8671863206f195299f8cd0a to your computer and use it in GitHub Desktop.
Save altitdb/f6709d09f8671863206f195299f8cd0a to your computer and use it in GitHub Desktop.
Find all external grants owner
SELECT * FROM table_privileges WHERE owner = 'OWNER_NAME' ORDER BY grantee, owner, table_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment