기본으로 작성된 Oracle Default 사용자 확인하기

Oracle DB

2024.05.15

Oracle Database 12.2.0.1.0 for Microsoft Windows x64 설치 하기가 끝나고 다음 SQL문으로 기본적으로 작성된 Oracle 사용자 명, 계정 상태 , 적용 Profile 를 확인할 수 있습니다.

COLUMN username format A23;
COLUMN account_status format A17;
COLUMN profile FORMAT A16;
SET PAGESIZE 100;
SELECT username,account_status,profile FROM dba_users;

실행 결과는 다음과 같습니다.( 이 버전에서는 USERNAME SCOTT가 존재하지 않습니다.)

C:\>sqlplus / as sysdba
 SQL*Plus: Release 12.2.0.1.0 Production on 일 1월 31 00:06:58 2021
 Copyright (c) 1982, 2016, Oracle.  All rights reserved.
 다음에 접속됨:
 Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
SQL> COLUMN username format A23;
SQL> COLUMN account_status format A17;
SQL> COLUMN profile FORMAT A16;
SQL> SET PAGESIZE 100;
SQL> SELECT username,account_status,profile FROM dba_users;
 USERNAME                ACCOUNT_STATUS    PROFILE
 ----------------------- ----------------- ----------------
 SYS                     OPEN              DEFAULT
 SYSTEM                  OPEN              DEFAULT
 XS$NULL                 EXPIRED & LOCKED  DEFAULT
 OJVMSYS                 EXPIRED & LOCKED  DEFAULT
 LBACSYS                 EXPIRED & LOCKED  DEFAULT
 OUTLN                   EXPIRED & LOCKED  DEFAULT
 SYS$UMF                 EXPIRED & LOCKED  DEFAULT
 DBSNMP                  EXPIRED & LOCKED  DEFAULT
 APPQOSSYS               EXPIRED & LOCKED  DEFAULT
 DBSFWUSER               EXPIRED & LOCKED  DEFAULT
 GGSYS                   EXPIRED & LOCKED  DEFAULT
 ANONYMOUS               EXPIRED & LOCKED  DEFAULT
 HR                      EXPIRED & LOCKED  DEFAULT
 CTXSYS                  EXPIRED & LOCKED  DEFAULT
 SI_INFORMTN_SCHEMA      EXPIRED & LOCKED  DEFAULT
 DVSYS                   EXPIRED & LOCKED  DEFAULT
 DVF                     EXPIRED & LOCKED  DEFAULT
 GSMADMIN_INTERNAL       EXPIRED & LOCKED  DEFAULT
 ORDPLUGINS              EXPIRED & LOCKED  DEFAULT
 MDSYS                   EXPIRED & LOCKED  DEFAULT
 OLAPSYS                 EXPIRED & LOCKED  DEFAULT
 ORDDATA                 EXPIRED & LOCKED  DEFAULT
 XDB                     EXPIRED & LOCKED  DEFAULT
 WMSYS                   EXPIRED & LOCKED  DEFAULT
 ORDSYS                  EXPIRED & LOCKED  DEFAULT
 GSMCATUSER              EXPIRED & LOCKED  DEFAULT
 MDDATA                  EXPIRED & LOCKED  DEFAULT
 SYSBACKUP               EXPIRED & LOCKED  DEFAULT
 REMOTE_SCHEDULER_AGENT  EXPIRED & LOCKED  DEFAULT
 GSMUSER                 EXPIRED & LOCKED  DEFAULT
 SYSRAC                  EXPIRED & LOCKED  DEFAULT
 AUDSYS                  EXPIRED & LOCKED  DEFAULT
 DIP                     EXPIRED & LOCKED  DEFAULT
 SYSKM                   EXPIRED & LOCKED  DEFAULT
 ORACLE_OCM              EXPIRED & LOCKED  DEFAULT
 SYSDG                   EXPIRED & LOCKED  DEFAULT
 SPATIAL_CSW_ADMIN_USR   EXPIRED & LOCKED  DEFAULT
 37 행이 선택되었습니다.
 SQL>