Virtual Table in SQL

Angelo

Hi Navision Guru,

Where can I find Virtual table inside SQL table?
for example,I can't find "SID - Account ID" table inside SQL.

vaprog

[url=http://en.wikipedia.org/wiki/Virtual]Wikipedia[/url] wrote:

Virtuality, the quality of having the attributes of something without sharing its (real or imagined) physical form

The SID - Account ID Virtual Table[MSDN] is virtual, it has no physical representation (or, in this case no corresponding table object in SQL). It does not even appear to NAV as a regular table. In fact, it probably shares more properties with a function than with a table.

lvanvugt

Any virtual table in NAV is created on the run and as sucgh not stored in the database. See also: C/SIDE Virtual Tables.

Angelo

OK, Understand.....

is there anybody know how to map Navision SID to get User name in SQL script?

vaprog

I don't know what you need to do, but is there something among these: Security Functions (Transact-SQL)

Furthermore you can investigate the following tables where NAVdb is your Dynamics NAV database:

NAVdb.dbo.[Windows Login]
NAVdb.dbo.User
master.dbo.sysprocesses
master.dbo.sysdatabases
NAVdb.sys.database_principals
master.sys.syslogins
NAVdb.sys.sysusers
...