Oracle Database User permissions.

Discussion created by MWNiebuhr Employee on Apr 19, 2012
CA Process Automation Tech Tip by Michael W Niebuhr, Sr. Support Engineer, April 19th 2012.

Minimum list of User Permissions for the Oracle Database user assigned to PAM.

Every time the application starts (including the first time, after a patch...), it needs to check and possibly adjust the DB structure.

The User set for the connection between PAM and Oracle needs the following rights on the PAM schema

Select on all our tables
Update on all our tables
Create sequences
Create tables
Drop tables
Create indices
Drop indices
Alter tables

Oracle Database User permissions.