Oracle Database User permissions.

Document ID : KB000021383
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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

Solution:

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