Report on Live_Notification table

[steveturley]

Hi. I've created a report on the live_notifications table, following the advice from this thread - @Mentions - Query/Filter - IT Service Management - Question - ServiceNow Community

However, when it it used, even though the report is shared with 'Everyone', the users get the 'Security constraints prevent access to the requested page' message.

Could anyone advise? Thanks!

[Yousaf]

Hi Steve,

Please refer to this KB Article.

Report gives error: 'Security constraints prevent access to requested page' for the users who the re...

Mark Correct or Helpful if it helps.

[steveturley]

I'm presuming anyone other than 'Admin' users do not have access to the 'live_notification' table as I as an Admin can see the content of the report I've created.

However, looking at the table record, I cannot see any access controls (see below).

My questions are...

• how can 'Admin' see this if it isn't defined
• what is this best way to create access for a non-admin user?

Thanks!

[Yousaf]

Hi Steve,

1. There are 26 OOB ACL on live_notication table. Please open any record on live_notification table and right click on header and select Configure > All

and the one I highlighted is actually giving read access to admin.

2. I think you should create a role for those non admin users and pass that role in ACL 

 

ACL is a little complicated topic sometime ACL on parent table restrict access sometime *.* restrict access.

[steveturley]

Hi Yousaf

Many thanks for the reply. Is there any simple documentation or advice on creating a role & linking it to an ACL?

Thanks

Steve