Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, May 12, 2016 11:41 AM
Points: 612, Visits: 1,899
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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, May 12, 2016 11:41 AM
Points: 612, Visits: 1,899
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