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
Author
Message
Posted Friday, June 6, 2008 12:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, September 1, 2013 6:46 PM
Points: 21, Visits: 144
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