June 6, 2013 at 10:42 am
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?
June 7, 2013 at 10:50 am
Does the lack of responses mean the steps above ARE the best way to do this?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy