May 17, 2002 at 6:07 am
Hi all,
I need duplicate a database to be a test database. I make a restore with other name to the database, but the problem is, I need that the login access to test DB must be other and the owner of tables too.
Anybody knows how can I do it?
Thanks any help!
May 17, 2002 at 6:15 am
Ok are you saying you need to duplicate a database for testing and you have already done this? However, you need to have a different person to have access to this database and tables owned by another? If so then use EM to remove the current folks from the new test database and setup the new person(s) in it just like you had done with the old database (if this restore was to another machine you may need to use sp_dropuser to get them out properly, or sp_change_users_login to fix them if you want to keep them). Now as for changing the table owners you can use sp_changeobjectowner to do this but I suggest leave a dbo since it is easier to maintain a DB and ownership chains if done so. Information on the SPs can be found in SQL Books Online.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply