Help with 'Part of the query on sysauto has been ignored because of read security rules on sysauto.name'

[Mark178]

Hello, can anyone assist with this message when viewing the CMDB Health Dashboard Jobs: assumption is that it is ACL related, users have the ITIL role.

Part of the query on sysauto has been ignored because of read security rules on sysauto.name

The admin is unable to identify how to control access other than providing full admin.

[Shane41 · Accepted solution]

Hi Mark,

This error is relating to the Health Dashboard jobs

A user with only the itil role will not be able to view these scheduled jobs

To get rid of this message you will need to add the itil role to the read ACL (sys_security_acl table) for the sysauto table

Hope this helps,

Shane

[Mark178]

Thanks Shane!