Step 1: Create the "evisions" Oracle User

You will need to create a new Oracle user called evisions in each Banner^® Oracle instance where you will be using IntelleCheck. This user will own the Evisions IntelleCheck Oracle tables.

In SQLPLUS, type the following (changing the password/tablespace as needed):

CREATE USER EVISIONS IDENTIFIED BY PASSWORD DEFAULT TABLESPACE DEVELOPMENT TEMPORARY TABLESPACE TEMP;

Then, make sure that this user has appropriate access to be able to create the necessary tables.

In SQLPLUS, type:

GRANT RESOURCE, CONNECT, BAN_DEFAULT_CONNECT, BAN_DEFAULT_Q, CREATE TABLE, CREATE PUBLIC SYNONYM, DROP PUBLIC SYNONYM, UNLIMITED TABLESPACE TO EVISIONS;

GRANT SELECT ON GXVBANK TO EVISIONS;

GRANT SELECT ON PTRPICT TO EVISIONS;

Important Note

If you already have a user called evisions that is used for another Evisions product, ensure that this user has the BAN_DEFAULT_Q role. If this was not done when the user was created, it should be done now using the BANSECR process in Banner.