Access to the Change / Transaction Log

WolffWolff Member Posts: 3
I am reviewing a Navision user access setup, specifically for excessive access. I have three different user access profiles with preferences.

Could somebody please indicate if the user profiles / preferences below allow access (including add change and delete) to the change log)?

Note that Object Type "Table Data" with ID 405 (change log) has not been defined in any of the roles.

User 1
Object types: Table Data, Table, Form, Report, Dataport, Code Unit all have defined:
- Object ID = 0
- Read, Insert, Modify, Delete, Execute = Yes
- Security Filter = empty

The user also has System Object Types assigned (all rights set to yes)

Can this user access and modify (add, change, delete) the change log? In case specific System object types are required to do that, let me know - I can then verify.

User 2
Object types: Table Data, Table, Form, Report, Dataport, Code Unit and System all have defined:
- Object ID = 0
- Read, Insert, Modify, Delete, Execute = Yes
- Security Filter = empty
- No other lines defined
Can this user access and modify (add, change, delete) the change log?

User 3
- Object types: Table Data,
- Object ID = 0
- Read, Insert, Modify, Delete = Yes
- Execute = empty
- Security Filter = empty
- No other lines defined

Thank you very much for your help.

Comments

  • NRNR Member Posts: 78
    When you specify object id = 0(zero) to a particular object type, it indicates that the permissions granted would be applicable to all objects for that particular object type.

    For eg.
    Object Type :Table
    Object ID : 0
    Object Name
    Read Permission : Yes
    Insert Permission : Yes
    Modify Permission : Yes
    Delete Permission : Yes
    Execute Permission : Yes
    Security Filter Yes
    This enablesfull access to all tables. If specific permissions are to be given, then expand the objects and specify the necessary permissions.

    Hence, for User1 and User2, it has the permission to read,modify,delete,execute not only the change log "Table Data", but all the IDs of "Table Data"

    The User3 doesnt have access to the Table "Change Log". I believe for that particular user, it might allow. Am a little skeptical about User3.
  • WolffWolff Member Posts: 3
    Hello NR,

    Thank you very much for your quick response, appreciated. COuld you tell me how I can verify access to these tables through the Navision menu structure, i.e. what is the menu path I need to follow to access and chaneg the change log tables?

    Thanks in advance,
  • kinekine Member Posts: 12,562
    1) The access depends on User permissions AND License permissions
    2) If you have customer license, the permissions for Change Log entry are:

    TableData 405 Yes Indirect Indirect Indirect

    It means, you are not able to change the entries in this table without appropriate object. And there is no such an object, which allows you to change this entries...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.