Small and medium business | Business Central, N...

Limit permissions to see only its own entries

(0) Share

Report

Posted on by Hrvoje Kusulja

370

Hello,

I need to set up "permission set" so that each user (employee/purchaser) can (read/write) only its own Purchase Invoice records and not from other collogues. Based on "Purchaser code" and/or "assigne to" fields on Purchase documents (purchase invoice, posted purchase invoice, purchase order and purchase quote)

In permission, when doing filtering per entry, how can I set to be @=current user (or what is the syntax?)

I have lot of users, and trying to avoid having for each user its own permission set due to filtering per hardcoded value.

Thank you,

Kind regards

All responses (8)

Answers (0)

Suggested answer

YUN ZHU 86,253 Super User 2025 Season 1 on at

Like (0)

Report

RE: Limit permissions to see only its own entries

Hi, hope the following helps as well.

https://yzhums.com/8417/

https://yzhums.com/8427/

Thanks.

ZHU
Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: Limit permissions to see only its own entries

Yes, as per your needs.
Hrvoje Kusulja 370 on at

Like (0)

Report

RE: Limit permissions to see only its own entries

ah, ok, so without AL code and custom extension it is not possible to enter some syntax in filter column?
Suggested answer

Binesh 7,885 on at

Like (0)

Report
RE: Limit permissions to see only its own entries

You can customize the page extension if the Security filter not works for you.

See the below reference,

trigger OnOpenPage() begin FilterGroup(2); SetRange("Assigned User Id", UserId); FilterGroup(0); End
Hrvoje Kusulja 370 on at

Like (0)

Report

RE: Limit permissions to see only its own entries

Please advise how can I use Field Filter for current user using USERID ? Thank you
Hrvoje Kusulja 370 on at

Like (0)

Report

RE: Limit permissions to see only its own entries

Tx, but i do not plan to create for each user its own permission set. Pleas advise how can I use Field Filter for current user? Thank you
KTA 1,200 on at

Like (0)

Report

RE: Limit permissions to see only its own entries

You can use security filter base on purchaser code on permissions. If you want to do it by code, you would have to use function USERID.
Suggested answer

Vaishnavi J 3,060 on at

Like (0)

Report

RE: Limit permissions to see only its own entries

Hi Hrvoje Kusulja

1. You need to create copy of permission sets which is given to those employee/Purchaser.

2. Then add this security filter in respective table

3.Above is the example where I have given the Purchaser Code must be vaishnavi only that time it would give Read, Write, Modify permission otherwise no. And then assign this permission set to that user.

4. Please note if your employee or Purchase has super permission or any other permission sets which has full access on these table then you must remove that since it will override your new permission sets.

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much