Skip to content

Instantly share code, notes, and snippets.

@hsuyuming

hsuyuming/grant.sql

Created July 2, 2019 18:32
Show Gist options
  • Save hsuyuming/efcd1ec74793ba809e294ef6232a4b88 to your computer and use it in GitHub Desktop.
Save hsuyuming/efcd1ec74793ba809e294ef6232a4b88 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
grant.sql
CREATE DATABASE CREATE_STAGE_ONLY;
CREATE SCHEMA "CREATE_STAGE_ONLY"."TEST";
GRANT USAGE ON DATABASE CREATE_STAGE_ONLY TO ROLE SPARK;
GRANT USAGE ON SCHEMA CREATE_STAGE_ONLY.TEST TO ROLE SPARK;
GRANT CREATE STAGE ON SCHEMA CREATE_STAGE_ONLY.TEST TO ROLE SPARK;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment