created a new table and created a new role , how can i assign read capabilities to that role ?

[Servicenow lear]

hello all,

I have created a custom table in global scope and have created a role for it u_hello_read.

How can i assign read capabilities to it for the custom table ?

[Saurabh Gupta]

Hi,
By default ACLs got created while table creation with a default role if it did not in your case, please create a new ACL for read access on the custom table that you have created and give the role as you mention.

[Basheer · Accepted solution]

Hi @Servicenow lear ,

Ideally the ACL's would have got created when you are creating the table if you had checked in the box for Create ACL under Access Control sections.

It seems you've created a role "u_hello_read" and I suspect you created it manually and not created by system automatically.

2 scenarios come into picture right now

1. You ticked on Create ACL and system created role on its own

2. You didn't ticked on Create ACL and you created role

For 1st scenario

Already ACL would have been created, you can go to table and in the related list you can find out the ACL's, if you are unable to find the related list, configure it. If you want to edit the ACL's you need Security Admin role.

For 2nd scenario

ACL would not have been created, you need to elevate yourself to Security Admin role and create ACL

Type in ACL

click New

Type : Record

Operation : Read

Table : specify table name and column name : table.none should be in your case

Requires Roles : u_hello_read

Let me know if you've any more doubts.