Skip to content

Instantly share code, notes, and snippets.

@matejskubic

matejskubic/azure-create-user.sql

Created August 30, 2023 13:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • 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 [name@domain.com] FROM EXTERNAL PROVIDER
sp_addrolemember @rolename = 'db_datawriter', @membername = 'name@domain.com'
sp_addrolemember @rolename = 'db_datareader', @membername = 'name@domain.com'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment