Compare Users
Did you know Oracle provides an efficient way to compare users to quickly identify discrepancies in their access permissions? This is in addition to compare roles feature provided by Oracle. By examining both direct and inherited roles, you can easily identify any missing permissions and assign them as needed, ensuring all users have the correct access levels. This process helps maintain security and consistency across your system.
Here is how you can compare two users: Navigate to Tools >> Security or open the task Manage Applications Security Preferences task from Setup and Maintenance >> Search tasks option.
Navigate to Users >> Compare Users:
Select the First User and Second User you want to compare by clicking on search icon against each one and click on Compare:
To customize your comparison results, set the “Show” option to one of the values listed below:
- All: Compare all roles for both the users.
- Only in first user: Roles that appear in the first user but not in the second user.
- Only in second user: Roles that appear in the second user but not in the first user.
- In both users: Only those roles that appear in both roles
Here is an example of Only in second user:
You can also click Export to Excel to download the comparison data as a spreadsheet.
Click the Query By Example icon to enter the name of a specific role that you want to see from the search results.
Note: Users with below mentioned privileges are able to compare users:
- Create User Account (ASE_CREATE_USER_ACCOUNT_PRIV)
- Edit User Account (ASE_EDIT_USER_ACCOUNT_PRIV)
- View User Account (ASE_VIEW_USER_ACCOUNT_PRIV)
- Delete User Account (ASE_DELETE_USER_ACCOUNT_PRIV)
- Lock and Unlock User Account (ASE_LOCK_UNLOCK_USER_PRIV)
- Update Password for User Account (ASE_UPDATE_PASSWORD_FOR_USER_PRIV)
References:
** Oracle Document URL is subject to change with every upgrade.