Dzorzi
New Member.
234 views

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

0 Likes
1 Reply
Derek Giedd Honored Contributor.
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)
0 Likes
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.