Compare Roles
Did you know that Oracle offers an efficient tool for comparing roles? You can analyse two roles side by side to pinpoint their differences and similarities. This feature supports various role types, including job roles, abstract roles, HCM data roles, duty roles, and aggregate privileges, allowing you to compare roles within the same category or across different categories.
Here is how you can compare two roles: Navigate to Tools >> Security or open the task Manage Applications Security Preferences task from Setup and Maintenance >> Search tasks option.
Navigate to Roles >> Compare Roles:
Select the First role and Second role you want to compare by clicking on search icon against each one. You can also set the filter criteria to identify the security artifacts to compare in each of the roles.
To customize your comparison results, set the Show option to one of the values listed below. This will help you specify which security artifacts you want to display in your comparison.
- All: All selected artifacts for both roles.
- Only in first role: Selected artifacts that appear in the first role but not in the second role
- Only in second role: Selected artifacts that appear in the second role but not in the first role
- In both roles: Only those selected artifacts that appear in both roles
An example of In both roles:
Note: The comparison is refreshed automatically if you change the Show or Filter Criteria values.
You can also click Export to Excel to download the comparison data as a spreadsheet.
Copy Privileges to the Second Role in the Comparison:
You also have the option to copy a specific privilege to the second role with a single click, without the need to open and edit the role. To enable Add to Second Role option:
- Set the Filter Criteria to either Function security policies or Data security policies
- Set the Show to Only in first role
To copy a selected policy to the second role, simply click Add to Second Role.
Click Yes on the warning:
The selected privilege will be added to the second role:
Note: The second role in the comparison must be a custom role
References:
** Oracle Document URL is subject to change with every upgrade.