OAE -- required privileges for the OAE extension

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

OAE -- required privileges for the OAE extension

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Applicable to Applications Manager Versions:  v7.1, v8.0

Symptoms

There are several privileges that are needed to install OAE.  Most of the privileges should already be present.  Our OAE install/upgrade will encounter exceptions like the following if these privileges are not already granted:

ORA-01031: insufficient privileges

---

Resolution

The Oracle Applications Oracle account apps must have the following privileges:

• Authority to create triggers, procedures, views and tables
• Authority to execute dbms_lock, dbms_output and dbms_dbpipe

Here are the SQL statements which must be run from the sys account to grant those rights if they are missing:

grant create trigger to apps;
grant create procedure to apps;
grant create view to apps;
grant create table to apps;
grant execute on dbms_lock to apps;
grant execute on dbms_output to apps;
grant execute on dbms_pipe to apps;

---