반응형
[상태 확인]
[oracle@datarac1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 31 09:51:29 2023
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
SQL> col USERNAME for a15
SQL> select USER_ID, USERNAME, ACCOUNT_STATUS from dba_users where USERNAME in ('SYS','SYSTEM');
USER_ID USERNAME ACCOUNT_STATUS
---------- --------------- --------------------------------
0 SYS OPEN
9 SYSTEM OPEN
SQL>[SYSTEM User 삭제]
SQL> show user
USER is "SYS"
SQL>
SQL> drop user system;
drop user system
*
ERROR at line 1:
ORA-28050: specified user or role cannot be dropped
SQL> drop user system CASCADE;
drop user system CASCADE
*
ERROR at line 1:
ORA-28050: specified user or role cannot be dropped
SQL>[SYS User 삭제]
SQL> show user
USER is "SYSTEM"
SQL>
SQL> drop user sys;
drop user sys
*
ERROR at line 1:
ORA-28050: specified user or role cannot be dropped
SQL> drop user sys CASCADE;
drop user sys CASCADE
*
ERROR at line 1:
ORA-28050: specified user or role cannot be dropped
SQL>[결론]
안된다.
그러니 이상한 소리 하지 말아라..
반응형