SQL>SELECT * FROM DBA_USERS;
SQL>CREATE USER USER_ID IDENTIFIED BY PASSWD
DEFAULT TABLESPACE TBS_CLUB TEMPORARY TABLESPACE TEMP;
/* CONNECTION 등 기본적인 권한을 부여함 */
SQL>GRANT CONNECT, RESOURCE TO UEBPP;
SQL>ALTER USER USER_ID IDENTIFIED BY PASSWD
DEFAULT TABLESPACE TBS_CLUB2 TEMPORARY TABLESPACE TEMP;
SQL>CREATE USER USER_ID IDENTIFIED BY PASSWD
DEFAULT TABLESPACE TBS_CLUB TEMPORARY TABLESPACE TEMP;
/* CONNECTION 등 기본적인 권한을 부여함 */
SQL>GRANT CONNECT, RESOURCE TO UEBPP;
SQL>ALTER USER USER_ID IDENTIFIED BY PASSWD
DEFAULT TABLESPACE TBS_CLUB2 TEMPORARY TABLESPACE TEMP;
'컴퓨터활용 > 오라클' 카테고리의 다른 글
| v$session (0) | 2003.10.12 |
|---|---|
| oracle user (0) | 2003.10.12 |
| oracle listener status check (0) | 2003.10.12 |
| ORACLE export / import 예제 (0) | 2003.10.12 |
| ORACLE DATA DICTIONARY TABLE (0) | 2003.10.12 |