오라클 유저 생성

본문 : http://www.ischo.net -- 조인상 //시스템 엔지니어

+++++++++++++++++++++++++++++++++++++++++++++++++++++++


오라클 유저 생성

sql> CREATE USER username IDENTIFIED BY password
DEFAULT TABLESPACE tablespace
TEMPORARY TABLESPACE tablepace
PROFILE profile
QUOTA integer ON tablespace;


유저변경

sql> ALTER USER username IDENTIFIED BY password
DEFAULT TABLESPACE tablespace
TEMPORARY TABLESPACE tablepace
PROFILE profile
QUOTA integer ON tablespace
DEFAULT ROLE [role/ALL/NONE];



유저삭제

sql> DROP USER username [CASCADE];