Solved

Database Level Permissions on Log Shipping Secondary

Posted on 2010-08-16
4
362 Views
Last Modified: 2012-05-10
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
Comment
Question by:dba2dba
4 Comments
 
LVL 7

Accepted Solution

by:
lundnak earned 250 total points
ID: 33447872
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
 
LVL 8

Author Comment

by:dba2dba
ID: 33449928
Thanks for the response lundnak:

I am also under the same opinion.

Any other ideas are welcome......
0
 
LVL 24

Assisted Solution

by:DBAduck - Ben Miller
DBAduck - Ben Miller earned 250 total points
ID: 33547714
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now