Deleting db_owner role from login

  • I need to remove db_owner role from a login.SQL server 2000, I went security/LoginsFound the login in question and went to properties/database access....I deselect the db_owner and when I click ok....I get the following error."Error 15405: cannot use the reserved user or role name 'dbo'"Any idea...why?

  • catchmekiran (10/19/2012)


    I need to remove db_owner role from a login.SQL server 2000, I went security/LoginsFound the login in question and went to properties/database access....I deselect the db_owner and when I click ok....I get the following error."Error 15405: cannot use the reserved user or role name 'dbo'"Any idea...why?

    Does this particular login own the database by any chance?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply