1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

FAULT: The user owns objects in the database cannot be dropped

Discussion in 'Plesk for Windows - 8.x and Older' started by John41, Jun 30, 2006.

  1. John41

    John41 Guest

    0
     
    Hello,

    Urgent

    We have a problem to remove a mssql database of a user.
    What can I do?

    ERROR:

    Unable to delete database user: The user owns objects in the database cannot be dropped

    John
     
  2. sergius

    sergius Golden Pleskian

    28
    57%
    Joined:
    Nov 6, 2005
    Messages:
    1,898
    Likes Received:
    0
    what plesk version?
     
  3. John41

    John41 Guest

    0
     
    Plesk 7.5.6

    Thanks
     
  4. poquelicot

    poquelicot Guest

    0
     
    I'm using this version of Plesk and I have the same problem... I've reach the quota of databases on my hosting service and I'm blocked !
     
  5. kami@

    kami@ Guest

    0
     
    Go to mssql webadmin for this database and delete all tables owned by this user and the user itself
     
  6. poquelicot

    poquelicot Guest

    0
     
    I found a solution : I had to drop every procedures owned by the user, and it worked !

    Thanks for your reply, hope it will help some people !
     
  7. Traged1

    Traged1 Guest

    0
     
    You might also want to try dropping all "User Defined Functions".
     
Loading...