[Oracle] 유저생성

$ sqlplus "/as sysdba"

SQL> CREATE TABLESPACE TESTTABLESPACE

2 DATAFILE '/DB03/DBF/TEST.DBF' SIZE 10M;

TABLESPACE CREATED.

SQL> CREATE USER TESTUSER IDENTIFIED BY TESTPASSWD

2 DEFAULT TABLESPACE TESTTABLESPACE

3 TEMPORARY TABLESPACE TEMP QUOTA 500K ON TESTTABLESPACE;

USER CREATED.

SQL> GRANT CONNECT TO TESTUSER;

GRANT SUCCEEDED.

SQL> GRANT CONNECT, RESOURCE TO TESTUSER;

GRANT SUCCEEDED.

SQL> GRANT CONNECT, DBA TO TESTUSER;

GRANT SUCCEEDED.

SQL> EXIT

$