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]

Hi Amlan,

Please let me know what changes I need to do in another ACL, do I need to make any changes to Requires role?

[amlanpal]

Hi Ravishankar,

All you need to do is to remove the existing role 'u_maximo_cmdb_ci_user' and add 'asset' role in each of the 4 ACLs.

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

[Mrman]

Hi Amlan,

But if I do that by adding   'asset' role in each of the 4 ACLs then "asset" will have create, delete , write access also right? I want this table to be visible for "asset" role and just read the data , no changes should be done . Please suggest.

Also , when I went to System Definition -> Modules I found this table module and visibility related list. can I do that here ? also can I check that override ?

[amlanpal]

Hi Ravishankar,

You mixed up 2 things. Let me clear you one by one.

First lets talk about ACL. Yes, correct you are. read ACL is the responsible for visibility of the table. So, you need to provide 'asset' role in that read type ACL only. Similarly if your requirement is to allow 'asset' users to update/write records on that table, you need to modify the 'write' type ACL too.

In your screenshot you are showing the module visibility. The ACL does restrict (generally) the table visibility, not the visibility of modules or applications. So, you need to modify the ACL along with the corresponding Module visibility in order to show them in module(s).

Hope this clears your idea a bit.

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

[Mrman]

Thanks Amlan for clarifying . Please see the below changes I made and please let me know if it is correct. Also I added the "asset" role in Module visibility also.