생성 썸네일형 리스트형 [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; 더보기 이전 1 다음