in

Dynamics User Group

Since 1995 - The Microsoft Dynamics Online User Community
Dynamics User Group » Microsoft Dynamics NAV / Navision » NAV / Navision - Microsoft SQL Server » Repport Navision Login Roles

Repport Navision Login Roles

Last post 08-24-2008 14:34 by Rashed. 3 replies.
Page 1 of 1 (4 items)
Write a New Post Sort Posts: Previous Next

  • 07-03-2008 14:33

    • Derald
    • Not Ranked
      Male
    • Joined on 07-02-2008
    • Maryland
    • Posts 3
    • Points 60

    Repport Navision Login Roles

    Reply Contact

    I have been searching and can not find this info...

    What are the SQL Server tables for Navision 4.0 that maintain the roles for each user login? Prior to my a employment here, database authentication was put in place. I want to switch to Windows AUthentication and I would like to replicate the current user roles to the Windows Logins.

    Thanks in advanced for any assitance.

    Derald
    • Post Points: 20

  • 07-03-2008 22:16 In reply to

    • Legosz
    • Top 500 Contributor
      Male
    • Joined on 02-19-2008
    • Toronto, ON
    • Posts 58
    • Points 930

    Re: Repport Navision Login Roles

    Reply Contact

    We're running 5.0 (which may be different), with Database authentication. The table that maps users to their roles is called [dbo].[Member Of]. Do you have that table in 4.0?

     cheers, Mark

    • Post Points: 20

  • 07-07-2008 16:14 In reply to

    • Derald
    • Not Ranked
      Male
    • Joined on 07-02-2008
    • Maryland
    • Posts 3
    • Points 60

    Re: Repport Navision Login Roles

    Reply Contact

    Perfect! Exactly what I was looking for. It is in Nav 4.0.

     Thanks,

     Derald
    • Post Points: 20

  • 08-24-2008 14:34 In reply to

    • Rashed
    • Top 50 Contributor
      Male
    • Joined on 08-05-2003
    • Washington DC
    • Posts 400
    • Points 6,790
    • DynamicsNAVMVP

    Re: Repport Navision Login Roles

    Reply Contact
    In Nav, on any from, you can hit Ctrl+F8 calle d(zoom) and a new window will appear and on top it tells you the source of the table name.
    • Post Points: 5
Page 1 of 1 (4 items)

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