mibuso.com

Hello,

is there a good method, function to have the SID from USERID actually connected to NAV?

USERID doesn't contain the "domain\" string but only the username....

Thank you very much

Hi Andy76

You referring to the lookup on the UserID in the User Setup form - where you can connect Nav Logins and Window Logins?

With thanks

Try this:

[url]recUserSID.RESET;
recUserSID.SETFILTER(ID,'*\' + USERID);
recUserSID.FINDFIRST;
MESSAGE('%1',recUserSID.SID);[/url]

One other piece of info that may help you:

The User SID virtual table contains the user's SID.
Important/potentially useful: It contains all of their SIDs. Which means if they are part of windows groups etc. (which might also have Nav permissions) you would have to do


so that should help understand what Kriki's code is doing.

Small correction: Do NOT use FINDFIRST if you use REPEAT-UNTIL. So:


BTW: important to remember about that table is that it only gives the SID's of CURRENT user. So if you want to know all the SID's of a user, you need to create a form/page/report/... on that table and then run it with the users credentials.