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;
This way to do it, is only appropriate if CalWin is the only application on the database instance.
Last updated
Was this helpful?