Prerequisites

Topics:

The following prerequisites must be available before proceeding with the iWay Oracle API wrapper installation:

Granting Privileges for the APPS and IWAY Database Users

This section describes how to grant the required privileges for the APPS and IWAY database users. You must grant these privileges before you install the iWay Oracle API wrapper.

Note: These privileges must be granted only if Oracle Applications is not installed.

For the APPS database user:

GRANT ALTER ANY PROCEDURE TO "APPS";
GRANT ALTER ANY TABLE TO "APPS";
GRANT ALTER ANY TRIGGER TO "APPS";
GRANT ALTER DATABASE TO "APPS";
GRANT ALTER SYSTEM TO "APPS";
GRANT ALTER USER TO "APPS";
GRANT CREATE ANY PROCEDURE TO "APPS";
GRANT CREATE ANY SYNONYM TO "APPS";
GRANT CREATE ANY TABLE TO "APPS";
GRANT CREATE ANY TRIGGER TO "APPS";
GRANT CREATE PUBLIC SYNONYM TO "APPS";
GRANT DELETE ANY TABLE TO "APPS";
GRANT DROP ANY PROCEDURE TO "APPS";
GRANT DROP ANY SYNONYM TO "APPS";
GRANT DROP ANY TRIGGER TO "APPS";
GRANT DROP ANY VIEW TO "APPS";
GRANT EXECUTE ANY PROCEDURE TO "APPS";
GRANT GRANT ANY OBJECT PRIVILEGE TO "APPS";
GRANT SELECT ANY DICTIONARY TO "APPS";
GRANT SELECT ANY TABLE TO "APPS";
GRANT UNLIMITED TABLESPACE TO "APPS";
GRANT UPDATE ANY TABLE TO "APPS";
GRANT "CONNECT" TO "APPS";
GRANT "RESOURCE" TO "APPS";

For the IWAY database user:

GRANT CREATE ANY PROCEDURE TO "IWAY";
GRANT CREATE SYNONYM TO "IWAY";
GRANT CREATE ANY TABLE TO "IWAY";
GRANT CREATE PROCEDURE TO "IWAY";
GRANT CREATE TABLE TO "IWAY";
GRANT CREATE TABLESPACE TO "IWAY";
GRANT CREATE TRIGGER TO "IWAY";
GRANT DROP ANY PROCEDURE TO "IWAY";
GRANT DROP ANY TABLE TO "IWAY";
GRANT DROP ANY VIEW TO "IWAY";
GRANT DROP PUBLIC SYNONYM TO "IWAY";
GRANT DROP TABLESPACE TO "IWAY";
GRANT EXECUTE ANY PROCEDURE TO "IWAY";
GRANT GRANT ANY OBJECT PRIVILEGE TO "IWAY";
GRANT GRANT ANY PRIVILEGE TO "IWAY";
GRANT INSERT ANY TABLE TO "IWAY";
GRANT SELECT ANY TABLE TO "IWAY";
GRANT UNLIMITED TABLESPACE TO "IWAY";
GRANT UPDATE ANY TABLE TO "IWAY";
GRANT "CONNECT" TO "IWAY";
GRANT "EXECUTE_CATALOG_ROLE" TO "IWAY";

Installing the GETCLOB Procedure

The getclob procedure must be installed under the schema the adapter uses to run Oracle APIs. To install the getclob procedure:

  1. Extract the iwse.ora script from the ibspsql.zip archive, which is located in the following directory:
    <iway_home>\etc\setup
  2. Run the iwse.ora script using SQL*PLUS.