• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

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.)

Thanks,
0
dba2dba
Asked:
dba2dba
2 Solutions
 
lundnakCommented:
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.
0
 
dba2dbaAuthor Commented:
Thanks for the response lundnak:

I am also under the same opinion.

Any other ideas are welcome......
0
 
DBAduck - Ben MillerPrincipal 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.
0
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now