AnsweredAssumed Answered

Restrict the user to see the Groups

Question asked by muthukumaran.mohanarengan on Jan 22, 2018
Latest reply on Jan 22, 2018 by Suman Pramanik

Hi ,

 

I created a Grid Portlet. If I filter my Id shows what the are the Groups i have assigned  and if I filter other userid it shows.

 

I want to restrict for other users. If the user login the clarity  that particular user can view his/her own Group, not for others.

 

Here is my code , how can I restrict for other users.

 

SELECT
   @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:ug.group_id:group_id@,
   @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:usr.USER_NAME:USER_NAME@,
   @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:usr.FIRST_NAME:FIRST_NAME@,
   @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:usr.LAST_NAME:LAST_NAME@,
   @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:grp.group_name:group_name@,
   @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:grp.description:description@
   from 
cmn_sec_user_groups UG,
cmn_sec_groups_v grp,
CMN_SEC_USERS usr
WHERE
ug.group_id = grp.ID
and ug.user_id           =usr.id
and grp.language_code = 'en'
AND usr.user_Status_id=200
and @filter@

Outcomes