Post reply

Identify Logins that are members of a Windows Group

  • February 25, 2012 at 7:51 am

    #256428

    I was granted permissions to a new Server that is pretty much managed by someone else.

    I determined that I was sysadmin on the old one by performing task that were restricted to sysadmin.

    I do not want to do that on this one.

    SInce I do not have permissions to use the Active Directory User Manager Tool can I get this information via a SQL Script?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • February 25, 2012 at 8:27 am

    #1451700

    take a look at this thread from just a day or two ago:

    Windows Group as Login linked to User Login

    I posted some examples of some extended stored procedures you can use to get details about either a windows group or an individual windows login.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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