How to give read access to Sys_Journal_field table?

Manikanta Vanka
Tera Contributor

We want to provide read access to sys_journal_field table. Could you please let me know the steps to provide the same.

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Manikanta,

I won't recommend giving explicit READ access to this table (sys_journal_field) via ACL since it holds journal entries for all journal fields across the instance

out of the box there are couple of READ ACLs on that table

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

7 REPLIES 7

Megha Padale
Giga Guru

Hi Manikanta, 

You can give access through ACLs , providing steps to create ACL:

navigate to system security-> ACL

type->new record

operation->read

table->sys_journal_field

field->*

and select role based on your condition.

It will give access to selected role.

If my answer helped you, please mark answer as helpful and correct.

Thanks and regards,

Megha.

Prasant Kumar 1
Kilo Sage

Hi,

Please follow the below steps & Screenshot:-

Step 1:- Go to User Menu on Click on Elevate roles.

find_real_file.png

 

Step 2:- security_admin check box should be checked and click ok.

find_real_file.png

 

Step 3:- Navigate to System Security->Access Control(ACL) and click on new.

find_real_file.png

 

Step 4:- Fill the ACL form to create read Access for Sys_Journal_field table.

find_real_file.png

 

find_real_file.png

 

In the Role Embedded List give your required Role.Or you can apply some filter condition also on condition builder.

 

 

If i was able to solve your query, please mark my answer correct and helpful.

Thanks & Regards

Prasant kumar sahu

Manikanta Vanka
Tera Contributor

Hi All,

I tried to write an ACL, but unable to create due to security restriction.

Requirements: We Want to extract the approval history/worknotes/comments from records.

Thanks in advance.