user has ITIL role but not able see records from asmt_metric_result table.

Bilasnew
Tera Contributor

One user has ITIL access. Not able see records from asmt_metric_result table.
We have checked from the access analyzer,user passed the table read and report view,query range,query match,report on.
But  still user not able to see data.

8 REPLIES 8

Tanushree Maiti
Tera Patron

Hi @Bilasnew 

 

Just once Grant the survey_reader or survey_admin role to the affected users and revalidate.

KB0714739 Unable to report on Survey or Assessment tables 

 

Its_Azar
Mega Sage

Hi there @Bilasnew

Check these:

 

Domain Separation restrictions

Before Query Business Rules on asmt_metric_result

Data filtration from User Criteria / Assessment conditions

Row-level ACL scripts returning empty results

 

Bilasnew
Tera Contributor

@Its_Azar 
Do you have any solution/recommendation of any approach to achieve this solution?

Ankur Bawiskar
Tera Patron

@Bilasnew 

did you try giving survey_reader role as per what @Tanushree Maiti mentioned?