Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vusil
Starting Member
22 Posts |
 Posted - 2005-10-07 : 04:00:22
|
| 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
12543 Posts |
Posted - 2005-10-07 : 05:05:45
|
| 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. |
 |
|
|
vusil
Starting Member
22 Posts |
Posted - 2005-10-07 : 06:26:10
|
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. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-10-08 : 00:20:03
|
| 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. |
|
|
|
|
|
|
Creating users on a read-only database