in

Dynamics User Group

Since 1995 - The Microsoft Dynamics Online User Community
Dynamics User Group » Microsoft Dynamics NAV / Navision » NAV / Navision - Microsoft SQL Server » Windows Login from SID

Windows Login from SID

Last post 08-11-2008 5:56 by girish.joshi. 1 replies.
Page 1 of 1 (2 items)
Write a New Post Sort Posts: Previous Next

  • 04-09-2008 14:58

    • najja
    • Not Ranked
    • Joined on 04-09-2008
    • Posts 1
    • Points 20

    Windows Login from SID

    Reply Contact

    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
    • Post Points: 20

  • 08-11-2008 5:56 In reply to

    • girish.joshi
    • Top 75 Contributor
    • Joined on 07-14-2006
    • Atlanta, Georgia
    • Posts 289
    • Points 6,887

    Re: Windows Login from SID

    Reply Contact

    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. 

    • Post Points: 5
Page 1 of 1 (2 items)

Copyright Dynamics User Group, 1995-2008, all rights reserved. This website and user group are independent and not affiliated with the Microsoft Corporation.