SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration / Script to Add User to all Databases / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 21:53:54 GMT20RE: Script to Add User to all Databaseshttp://www.sqlservercentral.com/Forums/Topic1050257-1550-1.aspxThat script doesn't actually work. But here is one that will:exec sp_msforeachdb 'use [?]; CREATE USER [UserName] FOR LOGIN [UserName];EXEC sp_addrolemember db_datareader, [UserName]'Thu, 21 Feb 2013 09:42:14 GMTalexandrialangRE: Script to Add User to all Databaseshttp://www.sqlservercentral.com/Forums/Topic1050257-1550-1.aspxThis script will add the user to each DB, but you must have the Login created first.It will add the user as a db_datareader role.[code="sql"]sp_msforeachdb 'use [?]; CREATE USER [MyDBUser] FOR LOGIN [MyDBLogin];EXEC sp_addrolemember ''db_datareader'', ''MyDBUser'''[/code]EnjoyMon, 11 Apr 2011 14:25:05 GMTYsaias Portes-QUI GroupRE: Script to Add User to all Databaseshttp://www.sqlservercentral.com/Forums/Topic1050257-1550-1.aspxIs this what you're looking for?[url]http://sqlserverplanet.com/security/add-users-to-database-script/[/url](don't know if it works properly, I just did a quick google search)Thu, 20 Jan 2011 05:19:46 GMTKoen VerbeeckScript to Add User to all Databaseshttp://www.sqlservercentral.com/Forums/Topic1050257-1550-1.aspxHello EveryoneI have lost my script that I use to add a user to all databases.Does anyone have one handy that you could share with me?ThanksAndrew SQLDBAWed, 19 Jan 2011 11:29:33 GMTAndrewSQLDBA