Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2008/03/30(14:05) from 61.81.167.93 | |
ÀÛ¼ºÀÚ : °ÁÙ±â (jkkang65@hanmail.net) | Á¶È¸¼ö : 3365 , ÁÙ¼ö : 13 |
[Oracle]Scott User ¿ÀºêÁ§Æ® »ý¼º ½ºÅ©¸³Æ® |
---|
1. °ü¸®ÀÚ·Î ·Î±×ÀÎ # sqlplus system/password as sysdba SQL> CREATE USER scott IDENTIFIED BY tiger DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; 2. ±ÇÇѺο© SQL> GRANT connect, resource TO scott; 3. ½ºÅ©¸³Æ®¸¦ ½ÇÇà SQL> CONNECT scott/tiger SQL> @$ORACLE_HOME/sqlplus/demo/demobld.sql |