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, 2016 Oracle and/or its affiliates. All rights reserved.