Content Platform Engine Oracle account

A database user account that Content Platform Engine uses to connect to Oracle databases containing the GCD and object stores.

Content Platform Engine database user (Oracle)
Unique identifier
cpe_db_user
Description
The owner account that Content Platform Engine uses to access Oracle. Use one account for the object store and one for the GCD.
In order to share database connections in Oracle, you must grant additional privileges to cpe_db_user . See the topic Sharing database connections in Oracle.
Minimum required permissions
Grant each cpe_db_user at least the following permissions:
  • CREATE SESSION
  • CREATE TABLE
  • CREATE VIEW
  • CREATE SEQUENCE
  • Alter user set QUOTA UNLIMITED on all table spaces used by db user
  • SELECT on pending_trans$
  • SELECT on dba_2pc_pending
  • SELECT on dba_pending_transactions
  • SELECT on DUAL
  • SELECT on product_component_version
  • SELECT on USER_INDEXES
  • EXECUTE on dbms_xa