Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version 3

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

3. Run the following scripts:

Code Block
CREATE USERLOGIN [testuser@onmicrosoft.com] FROM EXTERNAL PROVIDER;

CREATE USER [testuser@onmicrosoft.com] FOR LOGIN [testuser@onmicrosoft.com];

ALTER ROLE [db_datareader] ADD MEMBER [testuser@onmicrosoft.com];

ALTER ROLE [db_datawriter] ADD MEMBER [testuser@onmicrosoft.com];

ALTER ROLE [db_ddladmin] ADD MEMBER [testuser@onmicrosoft.com];

...

3. Run the following scripts:

Code Block
CREATE USERLOGIN [testuser@onmicrosoft.com] FROM EXTERNAL PROVIDER;

CREATE USER [testuser@onmicrosoft.com] FOR LOGIN [testuser@onmicrosoft.com];

ALTER ROLE [db_datareader] ADD MEMBER [testuser@onmicrosoft.com];

ALTER ROLE [db_datawriter] ADD MEMBER [testuser@onmicrosoft.com];

ALTER ROLE [db_ddladmin] ADD MEMBER [testuser@onmicrosoft.com];

...

3. Run the following scripts:

Code Block
CREATE USERLOGIN [testuser@onmicrosoft.com] FROM EXTERNAL PROVIDER;

CREATE USER [testuser@onmicrosoft.com] FOR LOGIN [testuser@onmicrosoft.com];

ALTER ROLE [db_datareader] ADD MEMBER [testuser@onmicrosoft.com];

ALTER ROLE [db_datawriter] ADD MEMBER [testuser@onmicrosoft.com];

ALTER ROLE [db_ddladmin] ADD MEMBER [testuser@onmicrosoft.com];

...