users and roles

• bodhilove

  SSCarpal Tunnel

  Points: 4035

  More actions

  August 31, 2008 at 12:13 am

  #70746

  Hi Folks,

  can anyone help me with a script to find db users and roles in sql 2000?

• Renuka__

  Hall of Fame

  Points: 3656

  More actions

  August 31, 2008 at 12:41 am

  #865463

  Hi,

  May be you can try this:

  sp_MSforeachdb sp_helpuser --for database wise user info

  sp_MSforeachdb sp_helprole --for database wise roles info

  [font="Verdana"]Renuka__[/font]

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  August 31, 2008 at 1:08 am

  #865465

  Yes, there are s4ch ones, and thry're installed on your workstation.

  Start SQL Profiler against one not busy server, desirably the one where there is nobody else but you.

  Go to Entrprise Manager and expand dtabse users. If it was expanded refresh it.

  Return to Profiler and see which commands EM used to get the list of the users.

  _____________
  Code for TallyGenerator