Dijalankan di user system dan pws manager

CREATE TABLESPACE “username”
LOGGING
DATAFILE ‘C:\ORACLE\ORADATA\CNSPR\username.ora’ SIZE 100M
AUTOEXTEND
ON NEXT  10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL

CREATE USER “username”  PROFILE “DEFAULT”
IDENTIFIED BY “password” DEFAULT TABLESPACE “username”
TEMPORARY TABLESPACE “TEMP”
QUOTA UNLIMITED
ON username
ACCOUNT UNLOCK;
GRANT CREATE PROCEDURE TO “username”;
GRANT CREATE TABLE TO “username”;
GRANT CREATE VIEW TO “username”;
GRANT GRANT ANY PRIVILEGE TO “username”;
GRANT QUERY REWRITE TO “username”;
GRANT SELECT ANY TABLE TO “username”;
GRANT “CONNECT” TO “username”;
grant select any table,insert any table,delete any table,update any table to username;