[ORACLE] USER생성

-- user 조회
select * from dba_users;

-- table space 생성
CREATE TABLESPACE basic_bbs_ts;
DATAFILE 'C:\oracle\product\10.2.0\oradata\basic_bbs\basic_bbs_ts.dbf' SIZE 100M;
(tablespace생성할때 DB서버에 경로가 존재해야 생성됨.)

-- user 생성
CREATE USER bbs IDENTIFIED BY bbs DEFAULT TABLESPACE basic_bbs_ts;


-- 권한
GRANT CONNECT TO bbs;
GRANT CONNECT, RESOURCE TO bbs;
GRANT CONNECT, DBA TO bbs;