Process
Log into an SQL Server through SQL Server Management Studio
Select the required database, right click and select ‘New Query’
Run the first line:
CREATE USER [username@yourdomain.com] FROM EXTERNAL PROVIDER
Then run one of the following lines depending on the level of access required for the database and individual:
Read Access:
ALTER ROLE db_datareader ADD MEMBER [username@yourdomain.com]Write Access:
ALTER ROLE db_datawriter ADD MEMBER [username@yourdomain.com] Owner:
ALTER ROLE db_owner ADD MEMBER [username@yourdomain.com]Example
Run this:
CREATE USER [username@yourdomain.com] FROM EXTERNAL PROVIDERThen run this:
ALTER ROLE db_datareader ADD MEMBER [username@yourdomain.com]
CloudSkills-PH 