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

Access to Snapshot only Expand / Collapse
Author
Message
Posted Thursday, June 6, 2013 10:42 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 529, Visits: 1,566
I want to give a group of users access to run select queries on a database snapshot but not the live database, but snapshots are Read-Only and that includes the security configuration.

One solution might be to run a script that
1) Adds the users to the live database db_datareader role.
2) Creates the database snapshot
3) Drops the users from the live database db_datareader role.

Is there a cleaner way to do this?

Post #1460805
Posted Friday, June 7, 2013 10:50 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 529, Visits: 1,566
Does the lack of responses mean the steps above ARE the best way to do this?
Post #1461162
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse