Are Windows Logins also Users ???

ecarmody

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

ara3n

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.

ecarmody

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

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");

ecarmody

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

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.