SQL database user cannot delete, prompting "the user cannot be dropped because the selected user owns the object" workaround
Due to the error of the MSSQL200 database, I restored an original database to the current SQL, at this time I came to the user, want to restore the user deleted, but the result is prompted "because the selected user has an object, so the user cannot be removed"
Because PB automatically establishes the table with the logged-in user name, this user name is the owner of the Table object (which can be directly deleted by the PB Auto-established table).
1. Open the Enterprise Manager, expand the server, right-click on the Local service, properties :
2. Select the Server Settings tab and tick allow direct modifications to the system directory
3. Open the Database system table sysusers, right-- Open Table -- return all rows
4. Select the user that should be added for the restore, find the related row, right-click Delete
5. You will be allowed to modify the system directory directly to restore.
The user cannot be dropped because the selected user owns the object