How to give read access to Sys_Journal_field table?

Manikanta Vanka · ‎04-05-2020

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

Ankur Bawiskar · ‎04-05-2020

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

View solution in original post

Hemant Goldar · ‎04-05-2020

Hi,

Goto>>Configure Dictionary>>of that Field>>Read only >>tick that field.

Hope this helps!
Please mark the reply as Helpful/Correct, if applicable.

Regards,
Hemant

Avinash1 · ‎04-05-2020

May i know the use case for the requirement ?

Journal Entries are always seen to Users/Agent bases on their ROLE(itil=min,unless you change the configuration )

Ankur Bawiskar · ‎04-05-2020

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

Indrajit · ‎04-05-2020

hey manikanta,

navigate to ->acl->create new . make sure you have elevate the role to security_admin.

in create new acl

type:- record

operation:- read

table name:- sys_journal_field and none

give role in roles as below screen shot

kindly mark Correct and Helpful if applicable.

Regards,

Indrajit.