Friday, 16 August 2013

Query to find the Securing attributes for User

SELECT fu.user_name "User", atr.attribute_code "Attribute",
       fa.application_name "Application", number_value "Value",
       fuc.user_name "Added By", ful.user_name "Updated By"
  FROM ak_web_user_sec_attr_values atr,
       fnd_user fu,
       fnd_application_tl fa,
       fnd_user fuc,
       fnd_user ful
 WHERE fu.user_id = atr.web_user_id
   AND atr.attribute_application_id = fa.application_id
   AND atr.created_by = fuc.user_id
   AND atr.last_updated_by = ful.user_id
   AND fu.user_name = UPPER (:user_name);

No comments:

Post a Comment