Script to get list of databases for which a user has db_owner database role ?

Question

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

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

You would need to loop through every database quering sys.database_role_members and sys.database_principals.

samihcl Old Hand Points: 304 More actions · Answer 2

Thanks for your immediate replay..

As i am oracle dba,not no much about pt in sql server 2008..

Pls elobrat your answer so it will help me lot .

Regards,

AJ@SQL SSC Eights! Points: 811 More actions · Answer 3

I also wanted something similar recently and used this article to get the list!

You may want to set a filter in the at the end as: loginname='<required user>'

Hope this helps!