Tag Archives: User Roles

SQL Query to List Oracle ERP Cloud Users and their Attached Roles

/***************************************************************************** *PURPOSE: SQL Query to List Oracle ERP Cloud Users and their Attached Roles * *AUTHOR: Shailender Thallam * *****************************************************************************/ SELECT pu.user_id, pu.username, ppnf.full_name, prdt.role_id, prdt.role_name, prd.role_common_name, prdt.description, TO_CHAR (pur.start_date, ‘DD-MON-YYYY’) role_start_date, TO_CHAR (pur.end_date, ‘DD-MON-YYYY’) role_end_date, prd.abstract_role, prd.job_role, prd.data_role, prd.duty_role, prd.active_flag FROM per_user_roles pur, per_users pu, per_roles_dn_tl prdt, per_roles_dn prd, per_person_names_f ppnf WHERE 1 =… Read More »