I want to create an ACL such that only the admin/ITIL role user can create/delete record in the table u_mytable ?

Rohan37
Giga Expert

What I did to allow only admin/itil role user to create/delete a record in the u_mytable table is that I openeed the OOB ACL and gave the ITIL user under roles and check admin overrides checkbox.

find_real_file.png

However, when someone who is a non-ITIL or non-admin is impersonating they are unable to even find the table after searching for u_mytable.list 

What to do regarding that ? Please provide me a script to write under ACL rules for create-write-delete-read

Such that only if the role is admin/itil they can create or delete a record u_mytable

and else they can only read-write a record if they have any other role other then Admin/ITIL

[ I need the script specifically, I don't want other methods ]

 

  

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Rohan,

you have modified the out of box create ACL;

so check the out of box read ACL on that table because user after doing u_mytable.list is unable to view records

so you want itil and admin to view as well; check if itil role is added to that out of box read ACL or not; if not add and then check

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

6 REPLIES 6

Ashutosh Munot1
Kilo Patron
Kilo Patron

HI,

We have to give read and write access to other people right?

So we need to create/Edit you READ ACLs as below:

1) Operation: Read

Name: u_mytable.none

role: may be public

no condition and no script

2) operation Read

Name:u_mytable.*

Role: Public

 

Thanks,
Ashutosh

your answer makes no sense to me