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 Oracle 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.