Portlet security groups

[Dzorzi]

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

[Derek Giedd]

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;