Options

What do extended store procedures in XP_NDO.DLL do

radiantradiant Member Posts: 2
edited 2008-04-07 in SQL General
We have had several clients that have tight controls on their servers and have asked us exactly what the two extended stored procedures (xp_ndo_enumsusergroups and xp_ndo_enumsids) do to the SQL server. All I have been able to find out is that they are needed to use windows authentication with NAV.

Can anyone elaborate on what these procedures actually do to the SQL installation?

-Radiant Technologies.

Comments

  • Options
    DenSterDenSter Member Posts: 8,304
    They don't do anything to the SQL Server installation, they are used by the NAV application to enable Windows authentication. One is to accommodate the standard security model and the other for the enhanced security model.
  • Options
    azerty74azerty74 Member Posts: 82
    These extended stored procedures are needed to be able to use Windows Authentication with Dynamics NAV running on Sql Server.

    The 2 versions (usergroups and usersids) are used depending if you choose the standard or enhanced security model.

    In this whitepaper you will find a complete explanation:
    Synchronizing Security in Microsoft Dynamics NAV 4.0 SP2

    Mind that there is an error in the name of the whitepaper. Only starting from Dynamics NAV 4 SP3 you have the possibility to choose between security models.
    Debugging is twice as hard as writing code. Therefore if you write the code as cleverly as possible you are by definition not smart enough to debug it.
  • Options
    kinekine Member Posts: 12,562
    You can just run the SPs to see the output. It is a list of data from Active Directory. It is used as central point for reading data from AD, in this case client itselfs do not need any functionality to read the AD and is using SQL tools to read the data...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    krikikriki Member, Moderator Posts: 9,090
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.