SP knowing NT detail

  • 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

  • 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."

  • have a look at:

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


    * Noel

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply