Content Platform Engine, Version 5.2.1   Database:  DB2 LUW          

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.

    Start of changeMinimum required permissionsEnd of change
    Start of changeUse your database tools to grant the following database permissions to this user account:
    • GRANT CONNECT ON DATABASE TO cpe_db_user
    • GRANT CREATETAB ON DATABASE TO cpe_db_user
    • GRANT USE OF TABLESPACE UserTablespace TO cpe_db_user
    • GRANT USE OF TABLESPACE UserTemporaryTablespace TO cpe_db_user
    • GRANT SELECT on SYSIBM.SYSVERSIONS TO cpe_db_user
    • GRANT SELECT on SYSCAT.DATATYPES TO cpe_db_user
    • GRANT SELECT on SYSCAT.INDEXES TO cpe_db_user
    • GRANT SELECT on SYSIBM.SYSDUMMY1 TO cpe_db_user
    • GRANT USAGE on workload SYSDEFAULTUSERWORKLOAD TO cpe_db_user
    • GRANT IMPLICIT_SCHEMA on DATABASE TO cpe_db_user

    For added security in a shared database environment, you can remove the Connect privilege from the Public group.

    Grant the following permissions if you want to use dedicated table spaces for Data, Index, and LOB.
    • GRANT USE OF TABLESPACE UserDataTablespace TO cpe_db_user
    • GRANT USE OF TABLESPACE UserIndexTablespace TO cpe_db_user
    • GRANT USE OF TABLESPACE UserLOBTablespace TO cpe_db_user
    • GRANT USE OF TABLESPACE UserTemporaryTablespace TO cpe_db_user
    End of change
  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.


Last updated: October 2015
p8ppi195.htm

© Copyright IBM Corporation 2013, 2015.