I have a standby database that is being restored in standby mode using log-shipped transaction files downloaded from a vendor's sFTP site on a daily basis.
Now, I am required to give a read-only access on this database to someone else, outside our domain. Since it is on standby, I can not create a user and grant read access. I also asked the vendor if they can do this for me on primary database but they said no.
So I am asking here if there is any way round to solve this problem?
If I change the database to online status and created a mapped user to the database, would that be okay to bring it back to a standby again and continue the restoring process without hassle?
Best Answer
No, that will break log shipping.
Unfortunately, until SQL Server 2014 you don't have much for other options.
In 2014+, you can use
CONNECT ANY DATABASE
andSELECT ALL USER SECURABLES IN SQL SERVER
to grant read only access.