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

Best Blogger TipsGet Flower Effect