반응형
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 |