[SQL][Oracle] 계정 생성, 권한 부여

 

-- 계정 생성
CREATE USER c##user IDENTIFIED BY password;

-- 계정 수정
ALTER USER c##user IDENTIFIED BY password;

-- 권한 부여
GRANT auth TO c##user;
-- ex)
GRANT CREATE SESSION TO c##user;
GRANT SYSDBA TO c##user CONTAINER=ALL;
GRANT CONNECT, DBA, RESOURCE TO c##user;

-- 계정 조회
SELECT * FROM ALL_USERS;
SELECT * FROM DBA_USERS;