The user cannot be dropped because the selected user owns the object

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.