Skip to content

Instantly share code, notes, and snippets.

@derekmurawsky

derekmurawsky/gist:8651988

Created January 27, 2014 16:35
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 derekmurawsky/8651988 to your computer and use it in GitHub Desktop.
Save derekmurawsky/8651988 to your computer and use it in GitHub Desktop.
Download ZIP
MSSQL statement to add a user to all databases on a server as a datareader.
Raw
gistfile1.sql
sp_msforeachdb 'use [?]; CREATE USER [MyDBUser] FOR LOGIN [MyDBLogin];EXEC sp_addrolemember ''db_datareader'', ''[MyDBUser]'''
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment