Hi,
I have this user that was given ownership of a couple of schema's and now I want to delete the user but an message appears saying I need to transfer ownership before doing so. The boxes that where ticked in SQL Server won't untick so how do I go about removing ownership of the schema and which user would of had ownership prior, it would have been the inital default user.
Anyone...please...
Schema Ownership
AlexB-007
Jim Stallings
Thank you Steve, I undertand the concept of ownership and why the user cannot be deleted. What I don't know is what user had ownership of the schema before I gave it to the user I'm trying to delete. Who owns the schema by default when you create a new database
Thanks for the ALTER AUTHORIZATION statement I didn't know that was the command, I just need to know who to give ownership too.
Nino Benvenuti
All objects, including schemas, have to have owners. If you could just delete the owner of the schema, it would no longer be owned by anyone and the security functionality relating to ownership chaining would stop working.
So before you can drop the owner, you have to assign ownership of the schema to another user. You can do this in Management Studio GUI, or you can use the ALTER AUTHORIZATION statement in T-SQL to do the same thing.
Hope this helps,
Steve