OAE -- required privileges for the OAE extension

Document ID : KB000089594
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
OAE -- required privileges for the OAE extension
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;