Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Fields missing from database view report

Sharique Azim
Mega Sage

Hi All,

I see some fields are missing in the report/ list view of database view made on sys_journal table.

In the below picture (admin view) i can see the fields elements ,element id and Value

find_real_file.png

But for non admin the fields are missing..

find_real_file.png

Please suggest.

Regards,

Shariq

6 REPLIES 6

Element and Element ID is not visible to non admin users by default.


That's why discrepancy in fields.


Sharique Azim
Mega Sage

Hi All,



I realized that I had to create to new ACL records on the sys_journal_field table/fields read access with roles (itil and custom role) to make the fields visible.Previously ,there was two custom ACL on the sys_journal_field table where runbook_admin role was required for read access.



But,now i dont understand why the table records were missing/blocked even when the user was provided with runbook_admin,



I mean, the other ACls were simply doing the same job for itil/roles containing user like our previous ACL was doing,i.e giving read access to user having only runbook_admin. Strange isnt?




Regards,


Shariq