ユーザ作成Script cuser.sql

SET ECHO ON
SPOOL creusr.LOG

DROP USER username CASCADE;

CREATE USER username
IDENTIFIED BY username
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;

GRANT CONNECT,RESOURCE,SELECT_CATALOG_ROLE TO username;

SPOOL OFF

EXIT