Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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