Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

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
Vice Admiral
Vice Admiral

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)
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.