Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2002/11/16(19:41) from 210.117.182.156 | |
ÀÛ¼ºÀÚ : °ÁÙ±â (jkkang65@hanmail.net) | Á¶È¸¼ö : 3773 , ÁÙ¼ö : 58 |
Re: [Oracle/Admin] »ç¿ëÀÚ »ý¼º ¹× ±ÇÇѺο© |
---|
1. »õ·Î¿î »ç¿ëÀÚ »ý¼º SQL> create user jkkang identified by jkkang123 default tablespace user_data temporary tablespace temp quota 10M on user_data; 2. »ý¼ºµÇ¾î ÀÖ´Â »ç¿ëÀÚ Á¤º¸ °Ë»ö SQL> select username, default_tablespace, temporary_tablespace from dba_users; 3. Á¢¼ÓÇϱâ # sqlplus jkkang/jkkang123 ERROR: ORA-01045: user JKKANG lacks CREATE SESSION privilege; logon denied 4. ±ÇÇѺο© SQL> grant create session, create table to jkkang; 5. Å×À̺í»ý¼º SQL> create table test (name varchar2(10)); Table created. 6. ±âº»ÀûÀÎ RoleÀ» °¡Áö°í »ç¿ëÀÚ »ý¼º SQL> create user jkkang identified by jkkang123 default tablespace user_data temporary tablespace temp; SQL> grant connect, resource to jkkang; 7. ºÎ¿©µÈ Role °Ë»ö SQL> select grantee, granted_role from dba_role_privs where grantee='JKKANG'; GRANTEE GRANTED_ROLE ------------------------------ ------------------------------ JKKANG CONNECT JKKANG RESOURCE SQL> select grantee, privilege from dba_sys_privs where grantee in ('CONNECT', 'RESOURCE'); |