End Dated Responsibility Still Appears when User Logs On (Doc ID 780392.1)

Last updated on AUGUST 23, 2023

Applies to:

Goal

The System administrator end dated the responsibility 'User Management' for a user TestUser.    However when TestUser logged back on,  the responsibility was still there.  

This can happen if the user has more than one role assignment.   In this case,  this user had two: one of them was an inherited role that was still active.

If the System administrator has used the System Administration / Security User Define to end date a role and it still appears,  then the presence of an inherited role should be checked. 

To show the roles assigned to a user,  run the following select from sqlplus as the apps user:

Or, one can logo n to UMX Manager and query the role to reflect what the parent role is. 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.