오라클 계정 생성

********************* create user(as sysdba) **********************/ --create user create user zolla identified by zolla default tablespace zolla temporary tablespace zolla_temp quota unlimited on zolla profile default; --view quotas select * from dba_ts_quotas where username = 'zolla'; --grant role grant connect, resource to zolla; /*************************************************************************** * CREATE USER ***************************************************************************/ * * CREATE USER user_name * IDENTIFIED [BY password | EXTERNALLY | GLOBALLY AS external_name}] * * options * * options: * * DEFAULT TABLESPACE tablespace * TEMPORARY TABLESPACE tablespace * QUOTA {integer [K|M]|UNLIMITED} ON tablespace * PROFILE {profile|DEFAULT} * PASSWORD EXPIRE * ACCOUNT {LOCK|UNLOCK} --(default unlock) ****************************************************************************/