Post reply

Users in a Group

  • May 3, 2009 at 11:42 pm

    #202831

    Hi

    In my server Group(Windows authentication) conatins around 20 users

    How to view the users in sql server query form?,

    and theire privilieges?

    With regards

    Lee

  • May 4, 2009 at 1:20 am

    #987953

    Hello,

    I’m not exactly sure what you want to do.

    If you need a list of Windows Users in a Windows Group from within SQL Server, you could try using xp_logininfo

    e.g. EXEC master..xp_logininfo 'Your Domain\Your Domain Group', members

    To get the permissions for a particular Login e.g. one mapped to a Windows Group, via a query, then you probably want to use the Security Catalog Views. (Please see the relevant section in BOL).

    May be you want a combination of this data?

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

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

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