SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Creating users on a read-only database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vusil
Starting Member

South Africa
22 Posts

Posted - 10/07/2005 :  04:00:22  Show Profile  Reply with Quote
Hi guys,
I need to add a user to a read-only database.
This database is also a secondary on a log shipping pair.

My question is can I simply turn off the read-only option, add the user, then turn the option back on without affecting anything?

Thanks.

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 10/07/2005 :  05:05:45  Show Profile  Visit nr's Homepage  Reply with Quote
The whole point about log shipping is that the database is kept in step with the source database.

You can probably create a login for the user and give it a sid that already exists for a user in the database which will gve the login those permissions.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

vusil
Starting Member

South Africa
22 Posts

Posted - 10/07/2005 :  06:26:10  Show Profile  Reply with Quote
Hi Nigel,
The login and user exist on the source server and database.
On the destinatin server only the login exist. The database does not have the user and I can not add it, apparently because the database is read-only.

Does log shipping sync users as well?
Is my problem related to the database being read-only or the log shipping plan itself?

Thanks for the help.
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 10/08/2005 :  00:20:03  Show Profile  Visit nr's Homepage  Reply with Quote
I suspect the login on the destination has a different sid from that on the source server.
Try dropping the login and adding it with the same sid as the user in the database.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000