🔹 Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. 📌 Telegram Group : https://t.me/OracleApps88

💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram : https://t.me/apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com

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