I am working on a NAV end user permissions report and I need to be able to retrieve information from the Microsoft Dynamics NAV "SID - Account ID" object. While working on creating this end user permissions report, I discovered that the CalcFormula property for the [Login ID] field in the 2000000053 - Windows Access Control table is:Lookup("SID - Account ID".ID WHERE (SID=FIELD(Login SID))).
Can someone please tell me where the "SID - Account ID" object is located in NAV, and where I might be able to find this object within our back end NAV SQL database?
-NL
*This post is locked for comments
We can't see the CalcFormula property in SQL database.
Nilesh,
Looking at the CalcFormula property for the [Login ID] field in the 2000000053 - Windows Access Control table, there seems to be a table or some other object with the name of "SID - Account ID". I am trying to find this object within NAV and also within our back end NAV SQL Server database. Please let me know if you can assist me with this.
I noticed that the 2000000054 - Windows Login NAV table has the fields of SID and ID, but I see no reference to an object called "SID - Account ID" when looking at the design view of the 2000000054 - Windows Login NAV table.
Navision Table: "Windows Login" (ID: 2000000054 )
SQL Table:dbo.[Windows Login]
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
