Windows Login from SID

Business Central/NAV Technical Forum
1

Hello There,

When I opened the NAV (5.0) database from SQL Management Console (for Reporting from outside NAV) it is noticed that the Table 200…54 - Windows Login as well as Table 200…53 - Windows Access Control has only the SID column where if we read the table from object designer we can see User ID and Name columns. Does anybody has any idea how or if they are hiding it and if I need the User ID to be listed using an SQL Query how should I do that.

Regards

Najja

2

Tables 2000000053 and 2000000054 contain references to the virtual table “SID - Account ID”. The contents of this table are calculated on the fly in memory.

If you want to find the value in a SQL query, you should call the function select suser_sname( SID ) in SQL server. Note that the SID in the parameter is a binary representation of the SID, and in NAV you are getting a string representation of the SID.