Create a user for the Cognos Analytics content store database

  1. Verify that the character set for the content store database is Unicode.
  2. Create a user and grant the user these roles and privileges:
    • Roles
      • CONNECT
      • RESOURCE
      • DEFAULT ROLE ALL

      Note:

      The RESOURCE role is deprecated and may not be available in future Oracle Database releases.
    • Privileges
      • GRANT UNLIMITED TABLESPACE
      • GRANT CREATE VIEW

      Note:

      For more information on suggested settings for creating the content store in Oracle, please review the IBM Cognos documentation.
  3. Validate the database connection from the Cognos Analytics server by typing:

    sqlplus <contentuser_userid>@<tnsnames_alias>

    At the prompt, enter the content user password.

    If the test is successful, a SQL prompt appears, showing that you have logged on to the database server as the content store database user. An unsuccessful test generates an ORA- error. Consult your database administrator for help in troubleshooting errors.