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

스폰서 링크
Oracle DB
스폰서 링크

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>

댓글

제목과 URL을 복사했습니다