Securing the COGNOSCS database in DB2

IBM® Cognos® BI requires additional grants to create tables for internal use. After the first successful startup of the IBM Cognos BI server, you can revoke the additional privileges required for table creation for the database user in the IBM Cognos BI content store database.

Procedure

Use the following command to revoke the additional grants (substitute the IBM Cognos BI database user for the @DB_USER@ variable):

REVOKE  CREATETAB,IMPLICIT_SCHEMA ON DATABASE  FROM USER @DB_USER@;

For more information about database configuration for IBM Cognos BI on DB2®, see Suggested Settings for Creating the Content Store in DB2 on Linux, Windows and UNIX.