Security constraints prevent saving reports on table Task - displaying report getting error in repor

[Kat123]

After applying report_admin role, user is not able to edit report.

I have checked acl also, i didn't see anything is restricting it.

they are able to edit incident tabel report but task related not able to edit.

[Shivalika]

Hello @Kat123 

Task is the parent table of all the tables, he should only be having access to limited data there. Is he able to see full table when going to "task.LIST". It is obvious that task table will have security constraints, it's also base table. 

If not important, he should be creating report in the specific table only - both for best practise access management and also performance issues. Because filtering task table again and again is nothing but huge burden on system as task table is itself very huge. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Robert H]

Hello @Kat123 ,

Please provide a screen shot of the error, else we can only reply based on assumptions.

Here is mine:

The user who is creating a report also needs to have read access to the table that the report is based on.

That access is controlled by ACLs that typically specify roles and/or conditions that the user must meet.

You say that this is a report on the Task table. This table likely has certain read ACLs, not just for the base table but also for its child tables, like Incidents and Change Requests. the "Security constraints prevent..." message indicates that the user does not pass some or all of these ACLs. You would have to review those ACLs to find out which additional roles the user requires, or which conditions they do not meet.

Regards,

Robert

[Kat123]

when user press edit button this message will appear

[Ankur Bawiskar]

@Kat123 

seems you are using system table so you need to allow that in this property

glide.ui.permitted_tables -> update your table name here

https://<instance-name>.service-now.com/nav_to.do?uri=sys_properties.do?sys_id=c3dee8670a0a0aa70064b48de5ad973e

"Security constraints prevent saving reports on table Upgrade Details - displaying report as read-on... 

If my response helped please mark it correct and close the thread so that it benefits future readers.