Create Oracle user (schema) for CalWin

Create the user/schema

CREATE USER CW7 IDENTIFIED BY password
 DEFAULT TABLESPACE USERS
 TEMPORARY TABLESPACE TEMP
 QUOTA UNLIMITED ON USERS;

GRANT "CONNECT" TO CW7;
GRANT "DBA" TO CW7;
ALTER USER CW7 DEFAULT ROLE "CONNECT", "DBA";

Necessary grants for CalWin

grant execute on DBMS_ALERT to public;
grant execute on DBMS_AQ to public;

Last updated

Was this helpful?