Create an user for PowerBI reports

[cmaneu]

Asked by Nicolas Charles (Microsoft).
Create a readonly user for dev-trashroulette-database.windows.net, database dev-trashroulette.

[cmaneu]

CREATE LOGIN surfriderreport
	WITH PASSWORD = '34f80b80-5d59-4af4-840c-6282b5e9eb33' 
GO

USE dev-trashroulette
GO

CREATE USER surfriderreport
	FOR LOGIN surfriderreport
	WITH DEFAULT_SCHEMA = dbo
GO

-- Add user to the database owner role
EXEC sp_addrolemember N'db_datareader', N'surfriderreport'
GO

[ChristopheHvd]

Merci pour le script du coup ;)
Tu sais si on a d'autres user à créer?