An operating system account on the database server that
Content Platform Engine uses to access Db2 for Linux, UNIX and Windows databases containing the GCD and object stores.
Procedure
- Create the following database user account after the database
instance has been created:
Remember: The user
name length is restricted to no more than eight characters.
- Content Platform Engine database user (Db2 for Linux, UNIX and Windows)
-
- Unique identifier
-
cpe_db_user
- Description
- The IT administrator (ITA) creates this operating system account, after which the database
administrator (DBA) grants it additional database permissions. Separate accounts can be used for
each object store, but are not required.
Do not create databases with the RESTRICTIVE
option.
- Minimum required permissions
- Use your database tools to grant the following database permissions to
cpe_db_user:
- CONNECT ON DATABASE
- CREATETAB ON DATABASE
- USE OF TABLESPACE UserTablespace
- USE OF TABLESPACE UserTemporaryTablespace
- SELECT on SYSIBM.SYSVERSIONS
- SELECT on SYSCAT.DATATYPES
- SELECT on SYSCAT.INDEXES
- SELECT on SYSIBM.SYSDUMMY1
- USAGE on workload SYSDEFAULTUSERWORKLOAD
- IMPLICIT_SCHEMA on DATABASE
For added security in a shared database environment, you can remove the Connect privilege
from the Public group.
Grant the following permissions to
cpe_db_user if
you want to use dedicated table spaces for Data, Index, and LOB.
- USE OF TABLESPACE UserDataTablespace
- USE OF TABLESPACE UserIndexTablespace
- USE OF TABLESPACE UserLOBTablespace
- USE OF TABLESPACE UserTemporaryTablespace
Record this value in your customized Installation and Upgrade Worksheet. To find this property,
search the worksheet for instances of cpe_db_user.