Options

Listing Active Directory Users

sggsgg Member Posts: 109
we have an SQL Server Installation Of Navision.
We Use Windows Login as well as Database Login.
The Windows Users are Registered and Attached to Groups in Windows Active Directory.

Considering the above Setting:
How could one List the Active Directory Users belonging to a user Group In Navision?

Ultimately, this is our goal. we want to be able to List which Users have read access (for example) to a particular Object.
Sunday, Godwin G

Comments

  • Options
    kinekine Member Posts: 12,562
    Check the virtual table 2000000052 Windows Group Member.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    sggsgg Member Posts: 109
    Thanks Kine for your response.
    I checked the table Mentioned (2000000052) but found it to be empty.

    Does this Table contain the List of CURRENT LOGGED ON Windows Users?

    The List we are Interested in is that of ALL windows User Groups and Members (Whether currently Logged on or Not).

    Best Regards.
    Sunday, Godwin G
  • Options
    kinekine Member Posts: 12,562
    I tested it once again, and this table shows you all combination of Group GUID and User (group) GUID which are connected.

    Which version of NAV you are using?

    I tested it on 4.00SP2+update under Windows and DB Authentication with MS SQL option...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    sggsgg Member Posts: 109
    YES, you are right.
    The Table shows the Users That are CURRENTLY logged in.

    However, what we want are the Groups and users that are in Active Directory, whether they are loged in or not.

    By the way, we have Version 3.6 and I was not able to see the Records in the Virtual Table because I was checking from my Database (I was the only one logged into it and I logged in with Database Login)
    [/b]
    Sunday, Godwin G
  • Options
    mightykidmightykid Member Posts: 23
    have a look at table 2000000052 - Windows Group Member.
  • Options
    kinekine Member Posts: 12,562
    sgg wrote:
    However, what we want are the Groups and users that are in Active Directory, whether they are loged in or not.

    No, I can see all users and groups membership in this table. May be it is difference between Navision 3.60 and 4.00 or some permission problem. But in generally, this table shows you all memberships, not just the logged in users... Try it on version 4.00 with same account.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    sggsgg Member Posts: 109
    Thanks Kine.

    I could see the Groups in another Database although not in my Database.

    Thanks
    Sunday, Godwin G
Sign In or Register to comment.