Create the PFCapAdmin user on the Content Store database server
- Create the user PFCapAdmin on the Content Store database server and grant the user these roles and privileges:
- Roles
- CONNECT
- RESOURCE
- Roles
- 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.
- 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.