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:
- The database administrator (DBA) must create separate schema users
before you create the object store.
- The default table spaces for the separate schema user must be
specified in the CREATE USER command.
- Quota must be granted for each schema user to the index/lob/data
table spaces.
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:
- 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
- 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.
This 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.