Post reply

Couldn't find to which windows group login belongs to

  • February 25, 2014 at 10:50 am

    #290350

    Hello,

    There is a login which is windows authenticated and user is able to login using that login name to the data base from management studio. I wanted to know to which windows group login belongs to as there are too many groups. Can any one help me out please?

    Appreciate all your help

    Thanks,

    Kalpana

  • February 25, 2014 at 11:03 am

    #1692009

    What if the login belongs to multiple windows groups?

    I think this is yours sys-admin question.

    Regards,

    Igor

    Igor Micev,My blog: www.igormicev.com

  • February 25, 2014 at 11:29 am

    #1692023

    thanks for the reply

    Is there a way i can find all the groups it belongs to.

    I tried below queries. Executed xp_logininfo command for all the windows groups, to list its members. But couldnt find login was looking for

    SELECT name FROM master.sys.server_principals WHERE TYPE = 'G'

    exec xp_logininfo 'group name,'members'

    Thanks,

    Kalpana

  • February 25, 2014 at 11:38 am

    #1692029

    The active directory group(s) to which a sql server login belongs to in the OS, is maybe (obviously from your query) not added in sql server, so how could you know?

    Igor Micev,My blog: www.igormicev.com

  • February 25, 2014 at 11:46 am

    #1692032

    Use xp_logininfo:

    exec xp_logininfo '<groupname>','members'

    you can get fancy and cursor loop through all the groups on the server with the output going to a table so you can query all groups at once

Viewing 5 posts - 1 through 4 (of 4 total)

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