Azure SQL DB – SQL User verwalten / anlegen

jeweils einzeln ausführen.

use master

CREATE LOGIN ETLWrite WITH PASSWORD=’lpsigl31!#A!a’;

GO

use master

CREATE  USER ETLWrite FROM LOGIN ETLWrite

GO

use Datawarehouse

CREATE  USER ETLWrite FROM LOGIN ETLWrite

GO

use Datawarehouse

exec sp_addrolemember ‘db_owner’, ‘ETLWrite’;