April 17, 2007 at 5:20 am
I have a login which I need to delete for security purposes. The problem is the login owns several objects. I must firstly transfer the schema ownership to the dbo schema.
I need to do this using SSMS and without writing any T-SQL. Can someone explain how to do this please?
Thanks.
April 24, 2007 at 10:26 pm
On the general Tab of the Schema Properties (within the actual database) there is a Schema Owner field and a Search button. Search to who you want your Schema to now be owned by then save your changes. Once your schema is migrated to a new owner you can delete the users.
Catherine
Catherine Eibner
cybner.com.au
May 14, 2007 at 5:37 am
May 22, 2007 at 3:57 pm
I have searched for a new schema owner and selected dbo, then clicked ok. I presume this saves the changes?
I then go to the users section and right click > delete on the old schema owner. I get error 'drop failed for ' as the user owns a schema in the database.
It is so frustrating!! What am I doing wrong?
June 1, 2007 at 2:53 pm
Adam,
I'm experiencing the same problem. I'm about fit to be tied. Mine's a DB role that I was stupid enough to give ownership to another role. That's all I did, so i know it doesn't own anything else... but SMS will not let me delete squat.
June 1, 2007 at 2:57 pm
Ahh... got it. Opened the wrong window, and didn't notice. I should have opened the actual Schema dialog box and reassigned the ownership. I was opening the dialog box that was associated with the database role, not the database schema.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy