Creating a Content Platform Engine database user for Db2 for Linux, UNIX and Windows

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

  1. 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
  2. Icon representing the worksheet Record this value in your customized Installation and Upgrade Worksheet. To find this property, search the worksheet for instances of cpe_db_user.