Post reply

Security group for SQL server

  • May 25, 2011 at 12:35 am

    #389585

    Hi,

    One of the users wants to know the windows security group that has access to SQL server. Can I see them in logins? How can I find them?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • May 25, 2011 at 2:17 am

    #1329523

    select * from sys.server_principals where type_desc = 'WINDOWS_GROUP'

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

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