January 15, 2004 at 12:43 pm
I used the Sql 2K Copy Database Wizard to upgrade a sql7 to sql 2k database. Seemed to worked fine with the data. Even got all the accounts transferred.
Problem: it didn't get all the permissions right. For example, one account, originally a dbo of a database, transfeered over as a "normal" user account. This caused the applicaiton accessing that database to fail (lack of permission).
Any sure fire ideas how to get the permissions right correct on the new database?
TIA,
Bill
January 15, 2004 at 4:40 pm
You can change the db owner if you need to. sp_changedbowner.
I'd script out the permissions from the old db and this should run fine on the new db. The scripting for this hasn't changed.
January 16, 2004 at 9:45 am
Steve,
"I'd script out the permissions from the old db" ....
How would you do this?
Bill
January 19, 2004 at 10:20 am
How to script th epermission automatically ? Thanks.
Eugene
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply