Home Forums SQL Server 2008 SQL Server 2008 Administration Script to Add User to all Databases RE: Script to Add User to all Databases

  • February 21, 2013 at 9:42 am

    #1590036

    That 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]'