Post reply

Grant access to a user on snapshot database

  • 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

  • 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"

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply