Project and Portfolio Management Practitioners Forum
cancel

Security Setting using Custom token in child object

Highlighted
Wang guowen
Trusted Contributor.

Security Setting using Custom token in child object

Having problem with user access.

My scenario is like as below.

Each project belong to a functional unit.
i.e.ProjectA belong to FunctionalUnitA.
FuntionalUnitA is stored in token FUNCTION_UNIT_HD_SECURITY.

In project security , i use the following token:[REQD.P.FUNCTION_UNIT_HD_SECURITY] and the securty work whereby i am able to view.

However , when i apply the user access in the child object request type as below:[REQD="[PRJ="[REQ.P.KNTA_MASTER_PROJ_REF]".PROJECT_REQUEST_ID]".P.FUNCTION_UNIT_HD_SECURITY]
. It doesnt work.

When i thought it was because of the custom token formatting was wrong, so i try using it in notification for testing but the value i got was correct.
2 REPLIES
Volker Schoettn
Honored Contributor.

Re: Security Setting using Custom token in child object

Hi,

what is in the Functional Unit?

I'm not sure about the project security.
But Request Type or Workflow Security must be:
USER_ID, USERNAME, SECURITY_GROUP_ID, SECURITY_GROUP_NAME

Maybe the field validation gives the wrong content....

Regards
Volker
Wang guowen
Trusted Contributor.

Re: Security Setting using Custom token in child object

The validation used was
PPM - Security Group Id - All.
whereby the sql query is

select security_group_id, security_group_name, description
from KNTA_SECURITY_GROUPS
where UPPER(security_group_name) like UPPER('?%')
and (security_group_name like upper(substr('?',1,1)) || '%'
or security_group_name like lower(substr('?',1,1)) || '%')
order by 2;

I execute this and it return me.
security_group_id:100483
security_group_name:Functional Unit Head (CBG Tech)
description:Functional Unit Head (CBG Tech)

I try both security group name and security group id but still cannot work.