Post reply

Access to Snapshot only

  • June 6, 2013 at 10:42 am

    #394923

    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

    #1622135

    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