Hi @rajkumar,

1. In IEE, go to Create User screen and query for the user. 
2. Under the User Settings section, click on Security Settings.
3. Click on the link “View Security Summary for User <UserName>”. 

All the Permission Sets that are granted to the user and all the Permission Sets that are granted to those are shown in the list at the top. Navigator Preview shows the presentation objects that are granted to the user, which means it is granted to any of the listed Permission Sets.

Please refer to the following documentation as well:

https://docs.ifs.com/techdocs/Foundation1/040_administration/210_security/020_permission_sets/030_grant_permission_set_to_user/default.htm#Security_Summary

Hope this helps!

Hi @rajkumar

You can use the SQL query below. (The session language is Turkish. So, the description comes in Turkish.)

Query:

SELECT t.identity      username,
	   po_.role        permission_set,
	   po_.module      modul,
	   po_.po_id       screen,
	   po_.description screen_description
FROM   ifsapp.fnd_user_role_runtime t,
	   (SELECT pog.po_id,
			   pog.role,
			   po.pres_object_type,
			   po.pres_object_type_db,
			   po.module,
			   po.description,
			   po.allow_read_only,
			   po.layer_id,
			   po.change_info,
			   po.change_date,
			   po.info_type
		FROM   ifsapp.pres_object_grant pog,
			   ifsapp.pres_object       po
		WHERE  pog.po_id = po.po_id) po_
WHERE  t.role = po_.role
	   AND po_.pres_object_type_db = 'WIN'
	   AND t.identity LIKE nvl('&Username', '%')
	   AND po_.role LIKE nvl('&Permission_Set', '%')
	   AND po_.po_id LIKE nvl('&Screen', '%')

Output: