_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;