Programming/SQL
SQL / Oracle 오라클 / 권한 설정 / 로그인
with chu
2021. 3. 13. 21:18
728x90
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.
728x90