The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Portlet security groups

Highlighted
Dzorzi
Occasional Advisor

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
Frequent Visitor

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)
//Add this to "OnDomLoad" event