Joint Analysis System

JAS runs fine on Oracle 10, and the installation is the same except for two extra steps that are required by the Oracle DBA after the JAS database is set up and the initial install scripts are run.

Oracle 10 has increased security and the current JAS code will not successfully create the JAR users, so they must be created beforehand by the Oracle DBA.

First, create the JAR_ROLE:

CREATE ROLE JAR_ROLE;
GRANT CONNECT TO JAR_ROLE;
GRANT CREATE any TABLE TO JAR_ROLE;
GRANT DELETE ANY TABLE TO JAR_ROLE;
GRANT DROP ANY TABLE TO JAR_ROLE;
GRANT INSERT ANY TABLE TO JAR_ROLE;
GRANT UPDATE ANY TABLE TO JAR_ROLE;
GRANT CREATE any INDEX TO JAR_ROLE;
GRANT DROP ANY INDEX TO JAR_ROLE;
EXIT

Secondly, run this script to create as many JAR users as you think you will need. Each JAS user will need his own JAR account, so if you expect that there will be 10 different people using JAS, use this script to create JAR001 through JAR010.

CREATE USER JAR001  PROFILE DEFAULT  
IDENTIFIED BY password 
DEFAULT TABLESPACE JWARS_JAR  TEMPORARY TABLESPACE TEMP  QUOTA UNLIMITED ON JWARS_JAR ACCOUNT UNLOCK;
GRANT JAR_ROLE TO JAR001;

Note: The JAS software expects that the JAR users will start with 'JAR', so JARabc is fine, but USERJAR001 is not.