My Oracle Support Banner

Locked Users To Be Marked As EXPIRED And LOCKED ? (Doc ID 3008099.1)

Last updated on MAY 19, 2024

Applies to:

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

Goal

Below locked users are locked and maintained by oracle and audit recommendation to be convert LOCKED user into EXPIRED and LOCKED. 

SQL> select USERNAME,ACCOUNT_STATUS,ORACLE_MAINTAINED from dba_users where ACCOUNT_STATUS='LOCKED';

USERNAME      ACCOUNT_STATUS ORACLE_MAINTAINED
------------------------- -------------------------------- -
SYSTEM                 LOCKED                      Y
OUTLN                   LOCKED                      Y
OJVMSYS               LOCKED                      Y
SYSDG                  LOCKED                       Y
SYSKM                   LOCKED                      Y
SYS$UMF                LOCKED                     Y
SYSBACKUP            LOCKED                     Y
SYSRAC                 LOCKED                     Y
GGSYS                   LOCKED                     Y
GSMADMIN_INTERNAL LOCKED                Y
XDB                      LOCKED                     Y
DBSFWUSER          LOCKED                     Y
APPQOSSYS           LOCKED                     Y
ANONYMOUS          LOCKED                     Y
GSMCATUSER         LOCKED                    Y
REMOTE_SCHEDULER_AGENT LOCKED     Y
AUDSYS               LOCKED                      Y
GSMUSER               LOCKED                    Y
ORACLE_OCM           LOCKED                 Y
DIP                          LOCKED                 Y

20 rows selected.

 

Solution

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
Goal
Solution
References


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