Access controls for Incident Metric database view

[jeff_kramer]

I'm trying to set things up for my ITIL users so they can run reports off the Incident Metric database view.   Primary goal is to get user access to the Incident State Duration metric definition so they can start looking at how long incidents are in each incident state over the life of the incident.   The problem is that when the report is viewed by an ITIL user the report just says "Security constraints prevent access to requested page".

I've went into the Incident Metric database view and found that it was composed of information from the Metric Definition, Metric Instance, and Incident tables.   I gave users with the ITIL role read access to the Metric Definition and Metric Instance tables.   I then had an ITIL user view a report built off the Incident Metric database view again and it showed the same message - "Security constraints prevent access to requested page".

I'm wondering how I can set up the Incident Metric database view so that they can be reported on by users with the ITIL role.

[vijay111]

hello ,

Navigate to ACL table and edit the "incident_metric" - read operation ACL . Now add the required role and save.

Thanks!

[oldguy]

Hello,

I am new at this, but the incident_metric is a view and I can find no way to add a role to a view. I checked the ACL as suggested there is no entry there for incident_metric.

Thanks!

[jlaue]

Hello -

When you open the Database View, such as Incident Metric - it will show the tables that are joined to make that view.   You will need to take note of those tables, and then go in to the ACL (Access Control) - with Elevated Roles.   Find the table names (metric_instance and metric_definition for the Incident Metric view) and then go in to the entry with 'Read' and then you can add roles there.