question Re: Issue with ACL for Gantt chart/Planning tab of a project in SPM forum

Issue with ACL for Gantt chart/Planning tab of a project

ashwinipingle — Tue, 18 Feb 2025 14:08:39 GMT

Dear SPM experts,

We are using Xanadu version.

In our system, the users with it_project_user role are able to view the projects in read-only mode.

However the users with it_project_manager role are getting a message

"Loaded grid as read-only due to invalid dependencies"

Although we have modified ACLs, but I noticed that the tasks are not loading for the users with it_project_manager role. Surprisingly for it_project_user role the tasks do load.

I tried debugging for security but no luck. What else can I try to troubleshoot?

We have projects and sub-projects and each could have tasks/phases.

Re: Issue with ACL for Gantt chart/Planning tab of a project

PaulaaO — Tue, 18 Feb 2025 16:53:18 GMT

Hmm...might be a clash because it_project_user is contained by it_project_manager.

I was unable to download your attachment, can you share the screen shots separately? In which view are you getting the message? Form record in classic view, Planning Console (Classic or New PW)

What ACLs have you modified, for which table/s?

There is the sn_ppm_read role which is the readonly dedicated role for this product which might make your life easier even though it falls under a different licence.

Re: Issue with ACL for Gantt chart/Planning tab of a project

ashwinipingle — Wed, 19 Feb 2025 06:12:54 GMT

Following error for user with it_project_manager role

Following is how it shows for it_project_user role

Re: Issue with ACL for Gantt chart/Planning tab of a project

ashwinipingle — Wed, 19 Feb 2025 06:27:36 GMT

ACLs are modified for pm_project, pm_project_task and several fields of pm_project and pm_project_task tables

Re: Issue with ACL for Gantt chart/Planning tab of a project

Ankur Bawiskar — Wed, 19 Feb 2025 07:04:33 GMT

@ashwinipingle

does this work fine for admin?

Re: Issue with ACL for Gantt chart/Planning tab of a project

ashwinipingle — Wed, 19 Feb 2025 07:47:58 GMT

yes works fine for admin

Re: Issue with ACL for Gantt chart/Planning tab of a project

ashwinipingle — Wed, 19 Feb 2025 10:27:41 GMT

@Ankur Bawiskar yes it works fine for admin

Re: Issue with ACL for Gantt chart/Planning tab of a project

ashwinipingle — Fri, 21 Feb 2025 07:53:31 GMT

OK, this got resolved.

There was a before-query business rule on pm_project table that had custom script that was stopping the task display/read for role it_project_manager. This was fixed and issue is resolved.