Skip to content

Instantly share code, notes, and snippets.

@deadlydog

deadlydog/SetUserPermissionsOnAllSqlDatabases.sql

Last active August 29, 2015 14:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save deadlydog/8eb83a0f19685f9d5513 to your computer and use it in GitHub Desktop.
Save deadlydog/8eb83a0f19685f9d5513 to your computer and use it in GitHub Desktop.
Download ZIP
Loop through every SQL Server database on server, create user if they don't exist, and set that user's permissions
Raw
SetUserPermissionsOnAllSqlDatabases.sql
exec master.dbo.sp_foreachdb
'USE ?
IF NOT EXISTS (SELECT 1 FROM sys.database_principals WHERE name = ''Domain\UserOrGroup'')
BEGIN
CREATE USER [Domain\UserOrGroup] FROM LOGIN [Domain\UserOrGroup]
END
exec sp_addrolemember ''db_backupoperator'', ''IQMETRIXHO\Development'';
'
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment