AceAlfred
AceAlfred

Reputation: 1191

How to delete user with db_owner rights?

Is there an easy way to delete a user with db_owner rights?

Upvotes: 2

Views: 6316

Answers (1)

Widor
Widor

Reputation: 13285

There's a subtle distinction between being the dbo of a database and having db_owner rights.

Have you tried setting another user as the dbo of the database (see sp_changedbowner), then removing the original owner's rights before deleting?

Upvotes: 4

Related Questions