Previous Topic

Next Topic

Book Contents

Book Index

Create the PFCapAdmin user on the Content Store database server

  1. Create the user PFCapAdmin on the Content Store database server and grant the user these roles and privileges:
  2. Run the create_cap_table.sql script (located in the <Installation_Directory>\InForm\bin\DBOra\Reporting folder) to create a table called TRIAL_URLS within this user/schema.

    For more information, see create_cap_table.sql.

    Note: The CAP schema can reside in the content store database instance or a separate database instance.

  3. Validate the database connection from the Cognos 10 BI server by typing:

    sqlplus <contentuser_userid> @ <connection_string>

    When prompted, 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 PFCapAdmin 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.