- 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;
'_Programming > DataBase' 카테고리의 다른 글
Error. 1046 (0) | 2020.12.20 |
---|---|
MariaDB.명령어 (0) | 2020.12.19 |
Error.ORA-00001 (0) | 2020.10.20 |
Oracle.DBeaver (Free DB Tool ) (0) | 2020.05.26 |