Creating a Content Platform Engine database user for Oracle

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

1. Create the following database account after creating the database instance:

   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

2. Record this value in your customized Installation and Upgrade Worksheet. To find this property, search the worksheet for instances of cpe_db_user.