Security in Navision 4SP1 SQL

NizarNizar Member Posts: 61
hello,

I am upgrading my database from navision 2.60 to navision 4SP1 SQL.
In Navision 4SP1 SQL the table autorisation contain object of navision 2.60 which are deleted in version 4SP1 so it is impossible to synchronise connection.

Can you help me

Thank ]
(*,) s

Comments

  • ara3nara3n Member Posts: 9,257
    you need to run table Permission table. Filter on
    object ID <> 0 and
    object Name = ''

    this will show you permission for objects that do not exists. Delete them all and run synchronization for just one user.

    To run synchronization for just one user. Click on tools->security->database logins

    Select the user you want to synchronize. then click on tools->security->synchronize signle user.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • NizarNizar Member Posts: 61
    thanks now i can synchronise connexion.

    When i open a form an error message ocuured that user can't access to table.
    I verify that the table exist in his role

    can you help me
  • ara3nara3n Member Posts: 9,257
    Did they log out and in after you synchronized their permission?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.