SP knowing NT detail

• HRUSHIKESHA SAHU-227894

  SSC Veteran

  Points: 242

  More actions

  May 11, 2005 at 1:56 am

  #88876

  Hi

  Any one can help me in knowing NT-detail (User groups and Rights). I have a windows authentication UID. I want to know with what all group this users belogs to.

  Thanks

  Sahu

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  May 12, 2005 at 12:54 pm

  #558540

  here's a start .from BOL ...

   

  xp_logininfo [[@acctname =] 'account_name'] [,[@option =] 'all' | 'members']

      [,[@privelege =] variable_name OUTPUT]

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

• noeld

  SSC Guru

  Points: 96590

  More actions

  May 12, 2005 at 1:44 pm

  #558550

  have a look at:

  IS_MEMBER ( { 'group' | 'role' } )

  
  * Noel