How to remove a SQL Server user with db ownership

Question

I need to drop the user using the dbowner schema from the SQL Server database. I can not refuse it, since I get this error message

Failed to fail for user network service. (Microsoft.SqlServer.Smo)

The database principle owns the schema in the database and cannot be deleted. (Microsoft SQL Server, Error: 15138)

When I try to uncheck the scheme owned by this user in order to remove the owner of db, it does nothing. My question is how can I delete this user or change his name from the "network service" to "NT AUTHORITY \ NETWORK SERVICE"

Answer 1

.

- : https://web.archive.org/web/20160406021232/www.itorian.com/2012/12/the-database-principal-owns-schema-in.html

Answer 2

, , .

:

AdventureWorks

USE AdventureWorks;
SELECT s.name
FROM sys.schemas s
WHERE s.principal_id = USER_ID('your username');

:

ALTER AUTHORIZATION ON SCHEMA::db_owner TO dbo;

db_owner , .

, .

: SQL SERVER - : : 15138

Answer 3

,

Foo

:

Security → Schemas dbo, Properties:

Then change

Foo

on the

PSE

then I can delete the user I want to delete.

Answer 4

My problem was also solved with the above solution:

SELECT s.name
FROM sys.schemas s
WHERE s.principal_id = USER_ID('your username');

ALTER AUTHORIZATION ON SCHEMA::db_owner TO dbo;

Answer 5

ALTER AUTHORIZATION ON SCHEMA::[NT AUTHORITY\SYSTEM] TO dbo