PS C:\Users\Administrator> sqlcmd -S .
1> use DB1
2> go
Changed database context to 'DB1'.
1> drop user U1
2> go
Msg 15138, Level 16, State 1, Server WIN-922S55M9QDP, Line 1
The database principal owns a schema in the database, and cannot be dropped.
1> select name from sys.schemas where principal_id=DATABASE_PRINCIPAL_ID('U1')
2> go
name
----------------------------------------------------
db_ddladmin
db_datareader
db_datawriter
(3 rows affected)
1> alter authorization on schema::db_ddladmin to dbo
2> go
1> alter authorization on schema::db_datareader to dbo
2> go
1> alter authorization on schema::db_datawriter to dbo
2> go
1> select name from sys.schemas where principal_id=DATABASE_PRINCIPAL_ID('U1')
2> go
name
----------------------------------------------------
(0 rows affected)
1> drop user u1
2> go
No comments:
Post a Comment