-
[Oracle] basicDB/Oracle 2020. 3. 22. 15:00
# nologin
sqlplus /nolog
# sys login
sqlplus "/as sysdba"
# change password
after login
alter user USERNAME identified by NEW_PW
# select * from dba_users
https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_4174.htm#REFRN23302
DBA_USERS
DBA_USERS DBA_USERS describes all users of the database. Related View USER_USERS describes the current user. This view does not display the PASSWORD or PROFILE columns. Column Datatype NULL Description USERNAME VARCHAR2(30) NOT NULL Name of the user USER_I
docs.oracle.com
# 오류코드 라이브러리
'DB > Oracle' 카테고리의 다른 글
[Oracle] sum() over() (0) 2019.09.05