?
Solved

Database Level Permissions on Log Shipping Secondary

Posted on 2010-08-16
4
Medium Priority
?
367 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 7

Accepted Solution

by:
lundnak earned 1000 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 25

Assisted Solution

by:DBAduck - Ben Miller
DBAduck - Ben Miller earned 1000 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

765 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