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 13.2.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
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"
from MGMT$DB_USERS
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
Cause
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
Symptoms |
Cause |
Solution |