dbo corruption?
-
I have a DB in our SQL 2005 server that a user has made an alias user on. This alias user is an alias of their domain logon (domain\logon). Problem is they called the user "dbo". Now we cant get rid of this user from the database. It appears that this DBO alias user has ownership of the dbo schema, (and hense cant drop the user).
How can we get rid of this alias?
We have tried dropping the domain logon, but the orphaned DBO user still stays in the DB, and is still un deleteable as it still owns the DBO schema.
Ownership of DBO schema cannot (as far as im aware) be transfered, because DBO schema cannot be altered.
Any suggestions?
-
try this
ALTER
AUTHORIZATION ON SCHEMA::dbo TO some_one_else;
where some_one_else is an existent user of your db with a valid login
then try drop the user; it may work
-
Get the error:
Cannot alter the Schema 'DBO'
I recall reading from MSDN that sys, dbo and information_Schema cannot be altered.
any other suggestions?!!
-
Default system schemas can be altered or modified.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
Really? How do you alter them? I always thought that you cannot alter or modify system schemas?
-
It was a typo. Read as
Default system schemas can't be altered or modified.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply