Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Wednesday, September 14, 2011

Permission names for specific User

SELECT
fnd.user_id ,
fnd.description ,
p.permission_name
FROM
jtf_auth_principals_b u ,
jtf_auth_principal_maps pm ,
jtf_auth_role_perms rp ,
jtf_auth_permissions_b p ,
fnd_user fnd
WHERE
fnd.user_id ='Your USER ID'
AND FND.USER_NAME=U.PRINCIPAL_NAME
-- AND p.permission_name ='CSI_SEARCH_PRODUCT_VIEW'
AND u.jtf_auth_principal_id = pm.jtf_auth_principal_id
AND PM.JTF_AUTH_PARENT_PRINCIPAL_ID = RP.JTF_AUTH_PRINCIPAL_ID
and RP.JTF_AUTH_PERMISSION_ID = P.JTF_AUTH_PERMISSION_ID;

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect