InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 20:26:08 GMT20http://www.sqlservercentral.com/Forums/Topic1387642-391-1.aspxI also wanted something similar recently and used this article to get the list!http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=172689You may want to set a filter in the at the end as: loginname='<required user>'Hope this helps!Thu, 22 Nov 2012 02:59:28 GMTAJ@SQLhttp://www.sqlservercentral.com/Forums/Topic1387642-391-1.aspxThanks 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,Thu, 22 Nov 2012 02:49:42 GMTsamihclhttp://www.sqlservercentral.com/Forums/Topic1387642-391-1.aspxYou would need to loop through every database quering sys.database_role_members and sys.database_principals.Thu, 22 Nov 2012 01:47:24 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1387642-391-1.aspxWhat is the command to get list of databases for which a user has db_owner database role ?Wed, 21 Nov 2012 15:52:45 GMTMani-584606