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>
댓글