question

You can do like this. 1. Create a login on the principal server and add permissions to the database that you create a snapshot of. 2. Script out the created login with the script I attached [link text][1], run the script against your database (use databasename), copy the row that has the create login statement for your new login. 3. Run the copied text (create login) against the mirror server to create the login. 4. Delete the login you created on the principal server (do not remove the user permissions from the database) Now you have a user that can access the snapshot. Since you removed the login from the principal server this user can't login and access the principal database. And since the login and database permissions exist on the mirror server the user can access the snapshot. Logins are stored in the Master database which is not mirrored, so this trick can be used to to access snapshots. [1]: /storage/temp/2343-security-transfer-logins.txt