보관함

[ORACLE]오라클_유저 생성 및 권한 부여

AI 윤 선생 2021. 7. 17. 02:13
반응형


오라클 유저 조회
SQL> SELECT *
     FROM ALL_USERS;

USERNAME                                                        USER_ID CREATED
------------------------------------------------------------ ---------- --------
ORACLE_OCM                                                           21 14/05/29
DIP                                                                  14 14/05/29
OUTLN                                                                 9 14/05/29
SYSTEM                                                                5 14/05/29
SYS                                                                   0 14/05/29


유저 생성: 
SQL> CREATE USER B2B_MGR IDENTIFIED BY 9909;

User created.

권한 부여:
SQL> GRANT CONNECT,RESOURCE,DBA TO B2B_MGR;

Grant succeeded.

반응형