Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • 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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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