SQL / Oracle 오라클 / 권한 설정 / 로그인

---

SQL(Structured Query Language)

초기 계정 설정

---

 

계정 생성 후, 권한 주고 로그인하는법 - conn, create, grant, alter, show

SQL> conn system/manager
Connected.
SQL> create user java identified by java;
User created.
SQL> grant connect, resource to java;
Grant succeeded.
SQL> grant create view to scott;
Grant succeeded.
SQL> conn java/java
Connected.
SQL> alter user java identified by java1234;
User altered.
SQL> show user
USER is "SCOTT"

 

계정 unlock 하면서 비밀번호 설정 동시에 하는 법

SQL> alter user hr identified by hr account unlock;
User altered.