Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Create script for specific user withDB_Datareaderpermission in MSSQL SERVER 2005 Expand / Collapse
Posted Friday, June 6, 2008 12:03 AM


Group: General Forum Members
Last Login: Yesterday @ 5:41 AM
Points: 21, Visits: 152
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
Post #512697
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse