Restrict current user to see only his records

vidhya_mouli
Giga Sage

‎03-15-2023 02:46 AM - edited ‎03-15-2023 02:46 AM

I have a table u_employee with a reference field u_reference_1 (refers to users in sys_user). I want to restrict the read access to this table. Current logged in users should be able to read only the records that have their name. How can I do this using ACL?

0 Helpfuls
  • 984 Views
1 REPLY 1

Dhruv Chandan
Giga Guru

‎03-15-2023 02:53 AM

Hi,

 

It can be achieved through Read ACL on that table.

 

1. In the Name select the table and correspondingly select the field name.

Incident example as below:-

example 1.JPG

 

2. Then enter the following script in advance

 

if(current.caller_id = gs.getUserID())
answer = true;
 
 
Hope this helps.
 
Regards,
Dhruv