Roles

• Gerald Ray

  Valued Member

  Points: 53

  More actions

  November 25, 2005 at 8:30 am

  #95950

  I am trying to find out what roles the attached user has.

  I find the logged in user by using the command "Select System_User"

  What would I use to find out what roles / Groups the attached user belongs to.

• bond007

  SSCrazy

  Points: 2056

  More actions

  November 25, 2005 at 9:35 am

  #605874

  does sp_helpuser 'username' help?  Run it from from the database in which the user exists.

  
  Growing old is mandatory, growing up is optional

• Gerald Ray

  Valued Member

  Points: 53

  More actions

  November 25, 2005 at 11:02 am

  #605890

  Alright although sp_helpuser is not what I was looking for it lead me to the command

  exec sp_helprolemember 'role'

  Thanx