_Programming/DataBase

Oracle.명령어정리

Pro_go 2020. 10. 20. 11:51

- system/oracle로 접속

SQL> conn system/oracle

 

- User 정보 확인

SQL> select username, default_tablespace, temporary_tablespace FROM DBA_USERS;

 

- User생성

SQL> CREATE USER user_name IDENTIFIED BY user_password

 

- User 권한부여

[권한]종류 :

SQL> GRANT 권한 TO user_name

 

- User 비밀번호 변경

SQL> ALTER USER JSPUSER IDENTIFIED BY lion;

 

- User 삭제

SQL> DROP USER user_name;

 

- User lock확인

SQL> select username, account_status, lock_date from dba_users

 

- User lock해제

SQL> alter user user_name account unlock;