Skip to content

Instantly share code, notes, and snippets.

@besteban1989

besteban1989/azure-sql-snippets.sql

Last active March 26, 2021 16:59
Show Gist options
  • Save besteban1989/9ad13d0ba26deb8004610b8970aa94b1 to your computer and use it in GitHub Desktop.
Save besteban1989/9ad13d0ba26deb8004610b8970aa94b1 to your computer and use it in GitHub Desktop.
Download ZIP
[Azure SQL Snippets]
Raw
azure-sql-snippets.sql
-- Add an Azure AD user, make sure your connection is set to the target database
CREATE USER [the.email@domain.com] FROM EXTERNAL PROVIDER
GO
ALTER ROLE db_datareader ADD MEMBER [the.email@domain.com]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment