Permissions to allow users edit only their data - 3.70

Business Central/NAV Developers Forum
1

I am trying to setup permissions for purcahse prices on a 3.70 installation to allow users change or update their own data but not that setup by other users. Is there a way of achieving this through roles & permissions or is it a coding exercise?

Thanks

2

Well, it depends on how each user identifys “his/her” data …

One thing is to use the “Security Filters” within the “Role-Permissions” (further information you’ll find in the “System Installation & management” document.

If this is not sufficient for your purposes, then indeed it’s a programming “thing”. E.g. you could save the USERID in the OnInsert trigger when createing a new record, and then compare this ID with the current USERID on modifications, etc…

Another option could be to use a security add-on like the one from Lanham: http://www.lanhamassoc.com/securitymgmt.htm

3

What version of Navision are you using and are you using SQL as database server?

You can setup security filters for permission but only if you use SQL server. Security filters was only implemented by Navision for the General Ledger module and you could run into problem if you try to use them in other modules.

However using security filter could probably solve your challenge without the need for coding, but testing will have to confirm this. You requirement is rather simple so I don’t think you will face any issues if you only use them to control update of purchase prices.

Regards

Claus

4

Thanks for the replies,

Its version 3.70b but running on the Native db. It would sounds more and more like a coding task in my setup.

5

Yes, you will have to code (or use an add-on) if you are using the native database.

Regards

Claus