컴퓨터활용/오라클
오라클 유저 생성
멜번초이
2003. 10. 12. 00:12
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;