July 19, 2011

User is DB owner, can’t drop

By sqlches

Scenario:  Trying to drop a database user, and  get an error about not being able to change db_owner.

Solution:  Update the db_owner to be owned by sa.

Snippet:

EXEC sp_changedbowner 'sa'

 

 

This entry was posted on Tuesday, July 19th, 2011 at 3:43 pm and tagged with , , and posted in Security, T-SQL, Users. You can follow any responses to this entry through the RSS 2.0 feed.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

%d bloggers like this: