Are Windows Logins also Users ???

ecarmody
ecarmody Member Posts: 53
edited 2008-08-13 in Navision Attain
Hi all,

This is my secong attempt to find out what I am missing.

We use SQL server and windows auth accounts. I can successfully create/add new accounts via Security - Windows Logins, and assign roles. User can then log on and run Navision application as needed.

Now what about the 2000000002 "User" table. Right now it is empty. The Windows Login table is populated as expected with all the logins I've added.

Is the "User" table suppose to also get automatically updated each time I add a new Windows Login? When I run Synchronize, nothing happens.

We have existing forms/code that do lookups to the User table. These lookups do not find the new users (windows logins) I've been adding. Are the existing forms/code the reference the User table support to be changed to reference the Windows Login table?

Appreciate your comments.
Cheers,
Eric

Comments

  • ara3n
    ara3n Member Posts: 9,258
    Hello

    Take a look at user setup table.

    On Validate and onlookup you'll see

    LoginMgt.ValidateUserID("User ID");

    LoginMgt.LookupUserID("User ID");



    This codeunit combines the users and shows them in one screen.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • ecarmody
    ecarmody Member Posts: 53
    My "91 User Setup" table does not have any code in its events.

    The "2000000002 User" is the one that is referenced by our forms/code, and it does not get populated with the windows logins.
  • garak
    garak Member Posts: 3,263
    which Version of Attain do you use :?:

    In Table 91 these code are not exist ?
    User ID - OnValidate()
LoginMgt.ValidateUserID("User ID");

User ID - OnLookup()
LoginMgt.LookupUserID("User ID");
    Do you make it right, it works too!
  • ecarmody
    ecarmody Member Posts: 53
    We have version US 1.10 (3.60) as shown in About box.

    When I go into Design mode for table 91 User Setup and then into the C/AL editor, there is no code in any of the fields for the OnValidate or OnLookup events.

    Is that not right?

    For you people who have SQL windows logins, what form or table do you do a lookup aginst for User Id field?
  • ara3n
    ara3n Member Posts: 9,258
    That's an old version wow.

    Well I suggest to download the 5.0 W1 db from mibuso. Get CU 418
    Login Management

    and use it in your db. I'm sure it was already in 3.6 version as well so no licensing issue will need to be resolved.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n

Categories