컴퓨터활용/오라클

오라클 유저 생성

멜번초이 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;