SBX - Search With Button

SBX - Forum Post Title

SQL query for user ID, roles and company

Microsoft Dynamics NAV Forum

sjc01234 asked a question on 13 Feb 2018 1:44 PM
My Badges

Question Status

Suggested Answer

From this post I got some information, but not all that I need. https://forum.mibuso.com/discussion/23627/how-to-get-windows-login

So, I understand that the windows logins are stored in Windows Login table. But according to the post above, if you are not synced with AD and running in "offline mode" then all you will see in the table is SIDs.  (Side note, how do I check this synchronization with AD?  Where in NAV do I find configuration for that?)

So, our table only has SIDs.   I want to see these logins as actual userId's - and I want to see them using SQL. 

I also want to see which roles each userId has, and whether that role assignment is for specific companies. I cannot find which table the role assignments are stored in.

Is this all possible purely with SQL?

Reply
Suggested Answer

Yes, you can easily join Windows Login and Access Control tables via a SQL query.

Reply
Suggested Answer

Yes, you can easily join Windows Login and Access Control tables via a SQL query.

Reply

SBX - Two Col Forum

SBX - Migrated JS