Project and Portfolio Management Practitioners Forum
cancel

Portlet security groups

Highlighted
Dzorzi
Regular Contributor.

Portlet security groups

Good morning

Is it possible to obtain the security groups setted for each portlet with a query in data model?

For example:

Portlet_name -----   Security_group

 

Thanks for support

1 REPLY
Derek Giedd
Honored Contributor.

Re: Portlet security groups

Try this. Just replace <portlet name>.

SELECT pd.NAME, sg.security_group_name
FROM dsh_portlet_defs pd, 
dsh_authorized_groups ag,
knta_security_groups sg
WHERE pd.NAME = '<portlet name>'
AND ag.portlet_def_id = pd.portlet_def_id
AND ag.group_id = sg.security_group_id;
-- Remember to give Kudos to answers! (click the KUDOS star)