[오라클] 유저 생성 & 삭제

D:\oracle\oradata\SCCOT.DBF

D:\oracle\oradata\SCCOT_INDEX.DBF

-------------------------------------------------------------------------------------------------

drop user sccot cascade;

drop tablespace sccot including contents and datafiles;

drop tablespace scott_index including contents and datafiles;

1. tablespace 생성

create tablespace sccot datafile 'D:\oracle\oradata\SCCOT.DBF' size 100M extent management local uniform size 1M;

create tablespace scott_index datafile 'D:\oradata\SCOOT_INDEX.dbf' size 50M extent management local uniform size 1M;

2. user 생성

create user sccot

identified by "sccot123"

default tablespace SCOOT

temporary tablespace temp

quota unlimited on SCCOT;

quota unlimited on SCCOT_INDEX;

3. 접속,리소스 권한 부여

grant connect, resource to sccot;

-------------------------------------------------------------------------------------------------

SELECT * FROM DBA_USERS ORDER BY USERNAME;

SELECT * FROM DBA_TABLESPACES ORDER BY TABLESPACE_NAME;

DROP USER XXX CASCADE;

DROP TABLESPACE XXX INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;