Database Level Permissions on Log Shipping Secondary

I am trying to give Read Only permissions on Log Shipping Secondary database. However, I am not able  to do it as
it was a readonly/standby database.

I understand that adding the user as read only on Primary database adds it in the secondary database also, once the logs are copied to and restored on secondary.

I wanted to know if there is a way to add database level permissions other than this (I dont want to use sysadmin permissions to access secondary database.)

Who is Participating?
lundnakConnect With a Mentor Commented:
I think adding the user with ReadOnly on the source database is your only option.
You can always disable the logon on the source server if you don't want the logon to have access to the source database server.
dba2dbaAuthor Commented:
Thanks for the response lundnak:

I am also under the same opinion.

Any other ideas are welcome......
DBAduck - Ben MillerConnect With a Mentor Principal ConsultantCommented:
That is your only option, to grant things to the source db, other than to grant server roles.  Access to the database is governed by adding things to the database, so Readonly pretty much is Readonly.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.