User unable to report on Incident Metric (incident_metric) table

[elizabethf_]

Hi - a user is trying to create a report using the Incident Metric (incident_metric) table but is receiving a message that "Security constraints prevent access to requested page." I did a search on this table (System Definition>Tables) but am not finding this table. Any help would be greatly appreciated. 

[Sebas Di Loreto]

Incident_metric is NOT a table.... it is a database view.

Type "database view" on the left nav and you will find it there.

In other words, it combines the incident table with the metric_instance table.

I am sure the user is getting the "security constraints..." message because of the metric_instance ACLs.

Only metric_admin or itil_admin can READ the metrics. 

Check the ACL at this link: /sys_security_acl.do?sys_id=91ffb701c0a801667f96049c6be622ca

Hope this helps.

[stefan_kreil]

For report view please also have a look at this ACL: /nav_to.do?uri=sys_security_acl.do?sys_id=e50a7793430121103545ebbd2ab8f2ce

[Pedro Grilo1 · Accepted solution]

Hi!

Incident Metric is a database view that combines metrics, metric definitions and incidents.

Probably the user does not have access to the metric definitions.

You will need to create a new READ ACL on incident_metric to grant the permissions.

I hope it helps!

Pedro

[i8ma2]

It's the roles, so just add up metric_admin and soap_query in user profile and you are good.