Skip to content

Instantly share code, notes, and snippets.

@OperationalFallacy

OperationalFallacy/gist:934421dae9f476166ffac40164859263

Created October 20, 2021 00:38
Show Gist options
  • Save OperationalFallacy/934421dae9f476166ffac40164859263 to your computer and use it in GitHub Desktop.
Save OperationalFallacy/934421dae9f476166ffac40164859263 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
show grants of role "blah";
select 'create-statement ' || "grantee_name" || ';' FROM TABLE(RESULTS_SCAN(LAST_QUERY_ID())));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment