Process Automation - Oracle Database User permissions.

Products

• CA Process Automation Base

Issue/Introduction

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

Environment

Process Automation 4.3 and above

Resolution

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

We need 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
• Create any view