Access to the Change / Transaction Log

Wolff · 2006-07-25

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.

NR · 2006-07-25

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.

Wolff · 2006-07-25

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,

kine · 2006-07-25

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...

Access to the Change / Transaction Log

Comments

Categories