Virtual Table in SQL

Angelo
Angelo Member Posts: 180
edited 2013-06-25 in NAV/Navision Classic Client
Hi Navision Guru,

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

Comments

  • vaprog
    vaprog Member Posts: 1,173
    [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
    lvanvugt Member Posts: 774
    Any virtual table in NAV is created on the run and as sucgh not stored in the database. See also: C/SIDE Virtual Tables.
    Luc van Vugt, fluxxus.nl
    Never stop learning
    Van Vugt's dynamiXs
    Dutch Dynamics Community
  • Angelo
    Angelo Member Posts: 180
    OK, Understand..... :)

    is there anybody know how to map Navision SID to get User name in SQL script?
  • vaprog
    vaprog Member Posts: 1,173
    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
    ...

Categories