오라클 유저 생성
CREATE USER 유저명
IDENTIFIED BY 패스워드
DEFAULT TABLESPACE 기본_테이블스페이스명
TEMPORARY TABLESPACE 기본_템프_테이블스페이스명
PROFILE DEFAULT
ACCOUNT UNLOCK;
오라클 유저 조회
SELECT * FROM DBA_USERS;
USERNAME |USER_ID |PASSWORD|ACCOUNT_STATUS |LOCK_DATE |EXPIRY_DATE |DEFAULT_TABLESPACE|TEMPORARY_TABLESPACE|CREATED |PROFILE |INITIAL_RSRC_CONSUMER_GROUP|EXTERNAL_NAME|PASSWORD_VERSIONS|EDITIONS_ENABLED|AUTHENTICATION_TYPE|
---------------------|----------|--------|----------------|-------------------|-------------------|------------------|--------------------|-------------------|------------------|---------------------------|-------------|-----------------|----------------|-------------------|
MGMT_VIEW | 74| |OPEN | |2020-04-12 14:38:16|SYSTEM |TEMP |2010-04-02 13:55:04|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
SYS | 0| |OPEN | |2020-04-12 14:37:31|SYSTEM |TEMP |2010-04-02 13:18:43|DEFAULT |SYS_GROUP | |10G 11G |N |PASSWORD |
SYSTEM | 5| |OPEN | |2020-04-12 14:37:31|SYSTEM |TEMP |2010-04-02 13:18:43|DEFAULT |SYS_GROUP | |10G 11G |N |PASSWORD |
DBSNMP | 30| |OPEN | |2020-04-12 14:38:11|SYSAUX |TEMP |2010-04-02 13:27:32|MONITORING_PROFILE|DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
SYSMAN | 72| |OPEN | |2020-04-12 14:38:12|SYSAUX |TEMP |2010-04-02 13:50:18|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
OUTLN | 9| |EXPIRED & LOCKED|2010-04-02 14:19:33|2010-04-02 14:19:33|SYSTEM |TEMP |2010-04-02 13:18:45|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
FLOWS_FILES | 75| |EXPIRED & LOCKED|2010-04-02 14:19:33|2010-04-02 14:19:33|SYSAUX |TEMP |2010-04-02 13:57:16|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
MDSYS | 57| |EXPIRED & LOCKED|2010-04-02 13:38:42|2010-04-02 13:38:42|SYSAUX |TEMP |2010-04-02 13:38:42|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
ORDSYS | 53| |EXPIRED & LOCKED|2010-04-02 13:38:41|2010-04-02 13:38:41|SYSAUX |TEMP |2010-04-02 13:38:41|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
EXFSYS | 42| |EXPIRED & LOCKED|2010-04-02 13:35:51|2010-04-02 13:35:51|SYSAUX |TEMP |2010-04-02 13:35:51|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
WMSYS | 32| |EXPIRED & LOCKED|2010-04-02 13:29:28|2010-04-02 13:29:28|SYSAUX |TEMP |2010-04-02 13:29:28|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
APPQOSSYS | 31| |EXPIRED & LOCKED|2010-04-02 13:27:34|2010-04-02 13:27:34|SYSAUX |TEMP |2010-04-02 13:27:34|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
APEX_030200 | 78| |EXPIRED & LOCKED|2010-04-02 14:19:33|2010-04-02 14:19:33|SYSAUX |TEMP |2010-04-02 13:57:16|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
OWBSYS_AUDIT | 83| |EXPIRED & LOCKED|2010-04-02 14:19:33|2010-04-02 14:19:33|SYSAUX |TEMP |2010-04-02 14:19:25|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
ORDDATA | 54| |EXPIRED & LOCKED|2010-04-02 13:38:41|2010-04-02 13:38:41|SYSAUX |TEMP |2010-04-02 13:38:41|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
CTXSYS | 43| |EXPIRED & LOCKED|2019-10-15 14:37:34|2019-10-15 14:37:34|SYSAUX |TEMP |2010-04-02 13:36:06|DEFAULT |DEFAULT_CONSUMER_GROUP | |10G 11G |N |PASSWORD |
ANONYMOUS | 46| |EXPIRED & LOCKED|2010-04-02 14:19:33|2010-04-02 14:19:33|SYSAUX |TEMP |2010-04-02 13:36:53|DEFAULT |DEFAULT_CONSUMER_GROUP | | |N |PASSWORD |
접속권한 부여
GRANT CONNECT,RESOURCE TO 유저명;
테이블스페이스 사용권한 부여
GRANT UNLIMITED TABLESPACE TO 유저명;
'DATABASE > ORACLE' 카테고리의 다른 글
| 오라클 시퀀스 생성/수정/삭제/조회 방법 (0) | 2020.01.13 |
|---|---|
| 오라클 인덱스 생성/삭제/리빌드/조회 (0) | 2020.01.13 |
| 오라클 제약조건 추가/삭제/비활성화/활성화 (0) | 2020.01.13 |
| 오라클 테이블스페이스 생성 (0) | 2020.01.10 |
| 오라클 언두테이블스페이스 데이터파일추가 (0) | 2020.01.10 |
