Hi, Is there any way to get details of screen users have access or any query from which we can get all screen access details for particular or for all users.
Solved
How to get details of users screen access via query APPS 10
Best answer by hhy38
Hi
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:
+31Hi
- In IEE, go to Create User screen and query for the user.
- Under the User Settings section, click on Security Settings.
- 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:
Hope this helps!
+16Hi
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:
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.