Skip to content

Instantly share code, notes, and snippets.

@matejskubic

matejskubic/azure-create-user.sql

Created August 30, 2023 13:54
Show Gist options
  • Save matejskubic/ab5dd94f0d01b46e9471da644dbbf33e to your computer and use it in GitHub Desktop.
Save matejskubic/ab5dd94f0d01b46e9471da644dbbf33e to your computer and use it in GitHub Desktop.
Download ZIP
SQL Azure add user to role
Raw
azure-create-user.sql
CREATE USER [[email protected]] FROM EXTERNAL PROVIDER
sp_addrolemember @rolename = 'db_datawriter', @membername = '[email protected]'
sp_addrolemember @rolename = 'db_datareader', @membername = '[email protected]'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment