IBM FileNet P8, Version 5.2.1            

Sharing database connections in Oracle

Sharing a single data source between different object stores in Oracle requires that you grant extra permissions to the primary database account (cpe_db_user).

Before you begin

If you want to assign separate table spaces during object store creation, you must do the following tasks: Without these steps, object store creation fails with an Oracle error that table space access is not allowed.

About this task

To share database connections in Oracle, you must grant extra privileges to the primary database user, cpe_db_user, the account that you provided while you ran the Configuration Manager's Configure Object Store JDBC Data Sources task.

Procedure

To grant extra database privileges to the primary database user:

  1. As the DBA, grant the following privileges, which enable the user account (cpe_db_user) specified in the data source for the database connection object to access object stores that have a different account than the schema user:
    GRANT ALTER ANY SEQUENCE
    GRANT ALTER ANY TABLE
    GRANT ANALYZE ANY
    GRANT CREATE ANY INDEX
    GRANT CREATE ANY SEQUENCE
    GRANT CREATE ANY TABLE
    GRANT CREATE ANY VIEW
    GRANT DELETE ANY TABLE
    GRANT DROP ANY INDEX
    GRANT DROP ANY SEQUENCE
    GRANT DROP ANY TABLE
    GRANT DROP ANY VIEW
    GRANT INSERT ANY TABLE
    GRANT LOCK ANY TABLE
    GRANT SELECT ANY SEQUENCE
    GRANT SELECT ANY TABLE
    GRANT SELECT ON ALL_USERS
    GRANT UPDATE ANY TABLE
  2. Decide on one of the following options:
    • Create the additional users to be used for creating more object stores: cpe_db_user1, cpe_db_user2, and so on.

      This option is necessary if you, the DBA, want to specify different table spaces. Content Platform Engine logs in to Oracle as the primary user, cpe_db_user and then creates objects for more object stores by prefixing the secondary user names onto the object name.

      For example, CREATE TABLE cpe_db_user2.TableName (...).

    • Grant the CREATE USER permission to the primary database user.

      Start of changeThis option allows a FileNet® P8 administrator to run the New Object Store wizard to create new object stores without having to ask the DBA to create more users. In this case, Content Platform Engine automatically creates the new object store's schema user whenever a new object store is created. If a password verification error occurs, see the following technote to resolve the error: http://www.ibm.com/support/docview.wss?uid=swg21969257.End of change



Last updated: March 2016
p8pcc168.htm

© Copyright IBM Corporation 2016.