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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-16 : 07:30:10
|
| Niel writes "Hi, I am having a little problem when aissigning the previliges to a new user after i restored a database to a new name.I have a database that is online and is working fine. A user has been created and assigned all necessary previliges for that database.However the tables created in that database are not under the user's ownership. The user can select,delete,insert,update the information in that database but the owner is dbo.Now i have to create a similar database (same structure and database) but the database name is different. I took a back up of existing database and restored with new name and file (with force option while restoring).The database has been restored and all the necessary tables and procedures have also come but the user that was created for existing(old database) has also been transferred to this new restored database.Now all i want to do is remove the preiviliges of that user in this new database and create a new user and assign that user the previliges for this new database.I am having problem while doing this.Please can anybody explain me the exact step as to how i can attain this task?Any help would be appreciated.Thank you" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-16 : 12:46:22
|
| Did you run sp_change_users_login after the RESTORE? Your users are orphaned if you didn't.Tara |
 |
|
|
|
|
|
Problem assigning privileges to user after restoring database