This is a handy little script to use for development databases, when you want all members of a certain domain group to be able to see all data in all databases, and view all definitions. Feel free to modify as desired!
EXEC sp_MSForEachDb ' USE ? IF NOT EXISTS (SELECT * FROM DBO.SYSUSERS WHERE NAME = ''sea\DevUsers'' ) CREATE USER [sea\DevUsers] FROM LOGIN [sea\DevUsers]
EXEC sp_addrolemember db_datareader, [sea\DevUsers] GRANT VIEW DEFINITION TO [sea\DevUsers] '
No comments:
Post a Comment