How to get a list of all users with dbo privilege?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 1

sp_helprolemember will list all role members in the current database. sp_helpsrvrolemember will do it at the server level.

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 2

I found the way.

EXEC sp_MSForEachDB 'USE ? SELECT name FROM sysusers WHERE sid = 0x01 AND name <> ''dbo'''

But yours is better.

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 3

I'd be careful of that approach. I don't think it will give you all appropriate members of db_owner.

At least its failing to find me on both my SQL 2000 and 2005 boxes.