[Oracle]사용자 생성 및 삭제

/* table space 생성 */
create tablespace ts_paint
datafile '/usr/lib/oracle/xe/oradata/XE/ts_paint.dbf' size 50M
autoextend on
next 1M
maxsize 100M
;

/* 임시 테이블 생성 */
create temporary tablespace ts_paint_temp 
tempfile '/usr/lib/oracle/xe/oradata/XE/ts_paint_temp.dbf' size 50M
extent management local uniform size 128k;
 
/* 사용자 생성 */
create user paint identified by paint 
default tablespace ts_paint
temporary tablespace ts_paint_temp;
   
/* 권한 부여 */
grant connect,resource to paint
   
/* 사용자 삭제시 */
drop user paint cascade;