Skip to content

Instantly share code, notes, and snippets.

@yai333

yai333/ad.sql

Last active March 25, 2021 01:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save yai333/40e2951cead72ac5888835d8b9ee9eeb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save yai333/40e2951cead72ac5888835d8b9ee9eeb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ad.sql
SET aad_validate_oids_in_tenant = off;
CREATE ROLE myuser WITH LOGIN PASSWORD '<YOU_IDENTITY_CLIENT_ID>' IN ROLE azure_ad_user;
CREATE DATABASE my-sp-db;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO myuser;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment