Users cannot access table

[Peter B]

Hello Community,

I created a catalog item (form) for my company's service portal. The issue is that the reference table my list collector variable is pointing at is only accessible for admin users. I believe that is a default ACL applied to all tables created but is there a way around that. We have not created nor assigned any roles for our non-ITIL users so they are all blank. Do I need to create a role or ACL for the table in order for regular users to access it? What is the easiest way?

Thank you in advance

[Allen Andreas]

Hi,

If the table is ok to be accessed, then you can simply create a "read" ACL for that table, with no role or conditions applied to allow them to read it. Again, this only allows "read" rights, not anything else.

You just want to be mindful increasing access for end-users and their ability to "read", etc.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Peter B]

Thank you Allen for the response. I thought I tried that but maybe I did it wrong. If possible, can you send me an example of an ACL with read only access to a table?

[Allen Andreas · Accepted solution]

Hi,

There's an additional layer to this with read.* as well...which could block users from seeing the records. So, you want to go to your ACLs for that table and look for any table.none and table.*, specifically for "read".

Hopefully, to make things less complex, there's no table.* "read" ACL.

Then all you'd need to do is create one like:

So make sure it's the right table, table.none, no role, no condition, and "read" Operation.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Peter B]

Thank you Allen, that worked! I was just pointing to the wrong table when I should of been pointing to sys_db_object.