List of Roles for current user

• b_avery@yahoo.com

  SSC Enthusiast

  Points: 197

  More actions

  March 1, 2005 at 2:56 am

  #88137

  Is there anyway of finding a list of roles that the current logged in users is a member of?

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  March 1, 2005 at 7:53 am

  #544614

  for a given database you could run sp_helpuser 'username'

  to run for all databases

   

  sp_msforeachdb "use ?; exec sp_helpuser 'username';"

  ---

  
  Shamless self promotion - read my blog http://sirsql.net