windows access control table


I am trying to create a script from sql server for NAV 2009 R2. When i run the script “select * from [Windows Access Control]”, it don’t returns the login id field. In fact its not available in the table columns also. but when i looked at object designer its available. So from where i can find the mapping of loginid and SSID?


Salman Fazal.

Welcome to DUG

LoginID is a FlowField so you cannot directly get it.

you have to write script to get it using existing field in table