August 2, 2016 at 4:48 pm
Hi,
How do I grant read access to a SQL user to the snapshot database ? The original mirror database do not have read access for this user .
Thanks,
PSB
August 3, 2016 at 1:29 pm
I don't think this is possible. Looking at the documentation on database snapshots they inherit the security settings of the base database at the time the snapshot was created.
A database snapshot inherits the security constraints of its source database at the time of snapshot creation. Because snapshots are read-only, inherited permissions cannot be changed and permission changes made to the source will not be reflected in existing snapshots.
Database Snapshots (SQL Server)
https://msdn.microsoft.com/en-us/library/ms175158.aspx
Joie Andrew
"Since 1982"
Viewing 2 posts - 1 through 2 (of 2 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