ACL For Custom Table

[user_20]

There is a custom table called “Certification and Training.”

We need to create ACLs with the following requirements:

1. Only users with the itil role should be allowed to create, update, and delete records in this table.
2. All users should be allowed to read/view the records in this table.

[Dr Atul G- LNG]

Hi @user_20 

Go to ACL and add role under that

Type : Creatte

table.*

Role: ITIL

https://www.servicenow.com/community/itsm-forum/acl/m-p/3186035

https://www.servicenow.com/community/itsm-forum/grant-user-create-access-to-table/td-p/568247

[Tanushree Maiti]

Hi @user_20 

1. Write ACL (ITIL Only)

a. 

• Type: record
• Operation: write
• Name: u_certification_training //your custom table name
• Advanced: No
• Role: itil

b. Create ACLs (ITIL Only) 

• Type: record
• Operation: create
• Name: u_certification_training //your custom table name
• Advanced: No
• Role: itil

c. Delete ACLs (ITIL Only) 

• Type: record
• Operation: delete
• Name: u_certification_training //your custom table name
• Advanced: No
• Role: itil

2. Read ACL (All Users)

• Type: record
• Operation: Read
• Name: u_certification_training //your custom table name
• Advanced: No
• Role: either leave empty or add public if needed, though empty is standard to allow all logged-in users.

[Tejas Adhalrao]

Hi @user_20  ,

Create ACL:

• Type: record
• Operation: read
• Table: Certification and Training
• Requires Role:  (leave empty)

This allows all users to view records.

and For itil users create following ACL's

Create ACL:  ( only ITIL user can create the record)

• Type: record
• Operation: create
• Table: Certification and Training
• Requires Role: itil

Create ACL:  ( only ITIL user can Update the record)

• Type: record
• Operation: write
• Table: Certification and Training
• Requires Role: itil

Create ACL:  ( only ITIL user can Delete the record)

• Type: record
• Operation: delete
• Table: Certification and Training
• Requires Role: itil

result 

• All users → can view records
• Only itil users → can create, update, delete 

[Ankur Bawiskar]

@user_20 

so what did you try and what's not working?

what debugging did you do from your side?