Oracle - 계정 관리
-- SYS 계정에서 사용자 계정 확인SELECT USERNAME, ACCOUNT_STATUS, EXPIRY_DATE, LOCK_DATE FROM DBA_USERS ORDER BY USERNAME; SELECT USERNAME, ACCOUNT_STATUS, EXPIRY_DATE, LOCK_DATE FROM DBA_USERS WHERE ACCOUNT_STATUS = 'OPEN' ORDER BY USERNAME; SELECT USERNAME, ACCOUNT_STATUS, EXPIRY_DATE, LOCK_DATE FROM DBA_USERS WHERE USERNAME = '계정명'; -- 계정 생성CREATE USER 계정명 IDENTIFIED BY "패스워드"; -- 계정 권한 부여GRANT CONNECT, ..