Previous Topic

Next Topic

Book Contents

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:
    • Roles
      • CONNECT
      • RESOURCE
  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 by running the following command from the Cognos Analytics server or the InForm application server:

    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.

Send Feedback