Re: Add user to R\O Database
- From: "Mark J. McGinty" <mmcginty@xxxxxxxxxxxxxxx>
- Date: Thu, 16 Mar 2006 17:46:55 -0800
"Toni" <teibner@xxxxxxxxxxxxx> wrote in message
news:evNCYtFSGHA.5736@xxxxxxxxxxxxxxxxxxxxxxx
I have a SQL 2000 Enterprise Edition sp4 production database that is log
shipping to 2 servers (one for DR purposes and the other for reporting).
On the reporting server, the database is in Read-Only mode. I need to
add another user to the database so they can run reports. How can I do
this with the database in read-only mode? I can't take it out of
read-only because I'll have to set up log shipping all over again, won't
I? This is a 40 GB database so that would take quite some time to do.
Do you have any suggestions?
The only way is to add that user to a role that has access... you could
create a server role that has SELECT permissions for all objects, but I'm
not sure that a new role's access would be grand-fathered into an r/o db.
Unfortunately, the only built-in role that leaves you with is sysadmin...
but it's worth a try.
-Mark
Thank you.
Toni
*** Sent via Developersdex http://www.developersdex.com ***
.
- References:
- Add user to R\O Database
- From: Toni
- Add user to R\O Database
- Prev by Date: Re: Cant Connect anymore
- Next by Date: Re: Error 18456
- Previous by thread: Add user to R\O Database
- Next by thread: Error 18456
- Index(es):
Relevant Pages
|
|
