derekmurawsky
1/27/2014 - 4:35 PM

MSSQL statement to add a user to all databases on a server as a datareader.

MSSQL statement to add a user to all databases on a server as a datareader.

gistfile1.sql
content_copyfile_download
sp_msforeachdb 'use [?]; CREATE USER [MyDBUser] FOR LOGIN [MyDBLogin];EXEC sp_addrolemember ''db_datareader'', ''[MyDBUser]'''