Re: Snapshot security



Consider disabling the logins on the mirror server. If you have to
failover, then you'll need to run a script to enable them.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Princy" <noname@xxxxxxxxxxxxxxxxx> wrote in message
news:81092706-6BB3-43A0-98BE-9A679745775A@xxxxxxxxxxxxxxxx
Hi,

We have a primary server and another server that is the mirror of the
primary server and a snapshot of the mirror on that same server. SS is
droped
and recreated everyday. Mirror also copies all the logins and security to
use
this as a DR server. So the Snapshot automatically migrates all the logins
and thus those with permission os SS can also access the primary.

Is there is any workaround to avoid this situation? I.e., those with
permission in SS should not have permission in primary.

--
Regards

Priw

.