Users Permissions in dB

• MegaDBA

  Hall of Fame

  Points: 3518

  More actions

  January 5, 2004 at 9:33 am

  #162933

  Hi Guys,

   

  I know its out there but where/what is it?  I need to know what users are sysadmins, dbo's or any other database role for that matter, is there a quick and simple way to find this info?

   

  TIA,

   

  aurora 

  
  

  Aurora

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  January 5, 2004 at 11:01 am

  #488673

  For fixed server roles: sp_helpsrvrolemember

  For database roles (fixed or user): sp_helprolemember   [This one must be run in the database]

   

  K. Brian Kelley
  @kbriankelley

• MegaDBA

  Hall of Fame

  Points: 3518

  More actions

  January 5, 2004 at 11:56 am

  #488684

  Duh, I could not remember that for the life of me...

  I was stumped after I ran sp_helpuser,

  and it was sooooo obvious all along.

   

  Thanks!

  
  

  Aurora