Read access to a custom table in Service Now.

[Mrman]

Hi All,

This is about making a custom table visible and can read the data within   .I created a custom table for populating data from a 3rd party tool via REST API .

Now requirement is to make this table visible to a role called "asset" , this role should be able to see and read the data in it. Please guide me .

I can see that default user role is populated under Controls related list , it has populated based on table name I given.

Please let me know if I can give "asset" role here . When I tried I am getting below confirmation , please suggest .

[Mrman]

Please let me know if it is not required to change user Role to "asset" under Controls related list ?

Just changing the role from 'u_cmdb_ci_user' to 'asset' in READ ACL would help ? please confirm .

[nthumma]

Yes, it would work.

[amlanpal]

Hi Ravishankar,

You need to modify the read operation ACL in order to make this table visible to the users having 'asset' role. Just remove the 'u_maximo_cmdb_ci_user' from the 'Requires role' and add 'asset' role instead.

Although I would encourage you to modify all 4 ACLs the same way mentioned above. Just keep every ACL in sync from access perspective.

PS: You need to have 'security_admin' role to create/modify any ACL.

I hope this helps. Please mark correct/helpful based on impact

[Mrman]

Hi Amlan,

I want asset role only to read the data and no one should be able to make changes to dat in this table .

So do I need to modify other ACLs as well apart from Read ACL ?

[amlanpal]

Hi Ravishankar,

Yes. You need to modify other ACLs too. Please have a look at this wiki link to understand the functionality of the operation types of any ACL.

I hope this helps. Please mark correct/helpful based on impact