i meant to assign an SQL Server login to the
database roles. But if a moment of sore tummy and tiredness, i accidentally give that user schema ownership of them instead:
Ignoring for the moment what it can conceptually mean for a user to "own" those two built-in schemas. And ignoring for the moment if it is even a problem if a user owns those two schemas (e.g. if i want to delete the users will the built-in schemas go with it).
My question is: How do i undo it?
ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO [db_datareader]F5
But that didn't do anything; so now it's time to consult the experts.
Microsoft SQL Server 2005 - 9.00.5057.00 (Intel X86) Mar 25 2011 13:50:04 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition