Create script for specific user withDB_Datareaderpermission in MSSQL SERVER 2005

• Saurabh S Kothari

  SSC Enthusiast

  Points: 173

  More actions

  June 6, 2008 at 12:03 am

  #208166

  select 'USE '+ Name +char (10) +'go' +Char (10)+ 'CREATE USER [domain\NtAccoount] FOR LOGIN [domain\NtAccoount] WITH DEFAULT_SCHEMA=[db_datareader]' +char (10) +'go' +Char (10) from sys.sysdatabases where dbid >5