My Oracle Support Banner

EM 13c: Users Account Details Are Not Upto Date in MGMT_$DB_USERS View In Repository Database (Doc ID 2711641.1)

Last updated on SEPTEMBER 26, 2020

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


In Enterprise Manager (EM) Cloud Control, User account details are not up to date in MGMT_$DB_USERS View.

SQL> select upper(NVL(SUBSTR(target_name,0,INSTR(target_name, '.')-1), target_name)) AS DATABASE,username "User",
profile "Profile", expiry_date "Expires On"
where expiry_date between (sysdate - 2) and ( sysdate + 7 )
and upper(NVL(SUBSTR(target_name,0,INSTR(target_name, '.')-1), target_name))='<DB_Name>'
ORDER BY 1,expiry_date DESC

xxxxxxx1 xxxx_PROFILE 9/21/2020 2:05:52 PM
xxxxxxx2 xxxx_PROFILE 9/15/2020 10:08:20 AM

From DBA_USERS Table

SQL> select username, expiry_date from dba_users where username in('xxxxxxx1','xxxxxxx2');

xxxxxx1  2/22/2021 1:03:53 PM
xxxxxxx2 2/28/2021 10:45:41 AM


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.