how to grant read access on a snapshot database (which is from a mirror)
Hi, The following situation: We have database A as a principal on sever S1. This database is mirrored to server S2. We create a snapshot on server S2 for this database (let's call this database B) For reporting purposes, I want to have user U1 read access to database B (role db_reader). But since database B is read only, it seems to be impossible. I already tried to create user U1 on server A and recreated snapshot B, but that doesn't seem to work either. Am I doing something wrong or is this not possible?