My Oracle Support Banner

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

Last updated on AUGUST 23, 2023

Applies to:

Oracle User Management - Version to 12.0.6 [Release 11.5 to 12]
Information in this document applies to any platform.


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. 






To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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