Incident Report with Questions allows only Catalog Admin to add the variables to the report

[gracjan]

Does anyone know why only Catalog Admin role can add the "Question" variables to the report column on the Incident table. Where Can I change that? The variables are on the item_option_new table but the table already has the read ACL set to "Public" OOTB. Why when we add the variables to the report are not appearing for an ITIL user only when we add the Catalog Admin role to the user. Is there way to change that so everyone (ITIL) has the ability to report on the variable fields when they need to. Please advise.

[mister_mentor · Accepted solution]

Gracjan,

Your issue here is one with access controls. The 'catalog_admin' role is setup with report_view and read ACL's for the question_answer table.

/now/nav/ui/classic/params/target/sys_security_acl.do%3Fsys_id%3D763017983be810108ed00d8044efc474

/now/nav/ui/classic/params/target/sys_security_acl.do%3Fsys_id%3D2ead0ea2eb9230003623666cd206fec7

The 'catalog_admin' as well as the standard 'itil' user have report_on access but that is meaningless.

To change from OOTB you would need to add the 'itil' role to the aforementioned ACL's.

[gracjan]

Thank you for enlightening me with your solution. You are my hero.