Create a user for the Cognos 10 BI content store database

Previous Topic

Next Topic

Book Contents

Create a user for the Cognos 10 BI 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
    • Privileges
      • CREATE ANY VIEW
      • UNLIMITED TABLESPACE
  3. Validate the database connection from the Cognos 10 BI 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.

Copyright © 2014, 2017 Oracle and/or its affiliates. All rights reserved.