Grant access to a user on snapshot database

• PSB

  SSChampion

  Points: 13195

  More actions

  August 2, 2016 at 4:48 pm

  #328619

  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

• Joie Andrew

  One Orange Chip

  Points: 27361

  More actions

  August 3, 2016 at 1:29 pm

  #1893585

  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"