User unable to access to report , how to fix?

[shabbir5]

Hi All,

I have a data base view (combination of incident table and sys_audit tables)

this report will show all incidents whos priority is changed 

incident number with old value and new value

report is done and working as expected , but when i shared the report with ITIL user i am getting security constraints error

i know admins can only access the audit table 

but anyway to give the access to this report to ITIL user ? please suggest

Thank you,

Shabbir Shaik

[Ankur Bawiskar · Accepted solution]

@shabbir5 

Things to check

1) give access to itil user on that database view table, create databaseViewTable.None READ ACL on your database view table and give itil role

2) give report_view table ACL for sys_audit table for itil role

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar · Accepted solution]

@shabbir5 

Things to check

1) give access to itil user on that database view table, create databaseViewTable.None READ ACL on your database view table and give itil role

2) give report_view table ACL for sys_audit table for itil role

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar · Accepted solution]

@shabbir5 

something like this

Name of database view in table field

Even after this it doesn't work then will have to give table.None READ ACL on sys_audit table for itil role

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@shabbir5 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Prathamesh26]

Hello @shabbir5 ,

Please create a Read operation ACL for sys_audit table.

You need to create table.NONE acl.

And add itil role under requires role.

Then try to access the report for itil user.

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this question to solved bucket. 

Regards,

Prathamesh