Users in a Group

  • 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

  • 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 1 (of 1 total)

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