Skip to content

Instantly share code, notes, and snippets.

@hsuyuming

hsuyuming/grant.sql

Created July 2, 2019 17:56
Show Gist options
  • Save hsuyuming/771b93cdf133fa231cf6bb28db864695 to your computer and use it in GitHub Desktop.
Save hsuyuming/771b93cdf133fa231cf6bb28db864695 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
grant.sql
GRANT USAGE ON DATABASE SPARK_PERMISSION_TEST TO ROLE SPARK;
GRANT USAGE ON SCHEMA SPARK_PERMISSION_TEST.PUBLIC TO ROLE SPARK;
GRANT SELECT ON TABLE SPARK_PERMISSION_TEST.PUBLIC.CUSTOMER TO ROLE SPARK;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment