Database Administration for Specific Platforms › Oracle/Windows Database Customization Procedures › Accessing Public Interface Views

Accessing Public Interface Views

Follow these steps:

1. Set ORACLE_SID=<Encyclopedia database name>.

   where: <Encyclopedia database name> is the name of the Encyclopedia database.

2. Open Oracle sqlplus.
3. Connect using the Oracle USERID and password you used during the installation.
4. Use Public Interface views to access tables and views.

Important! To populate or update Public Interface views, use the add or update models functions within the CSE. If you add or update outside of the CSE, you can corrupt the models, encyclopedia, or both.

During configuration of the CSE, an Oracle user ID and password were specified for connection to the Encyclopedia database. This is the userid associated with all encyclopedia tables and views. The CSE software connects to the databases using this user ID and password.

To avoid forcing users to qualify each view name, you can create a public synonym for each view.

You will need DBA authority to create Oracle userids in the Encyclopedia database (with connect authority), to grant these user IDs select access to views, and to create public synonyms.

Note: For more information, see the CA Gen Client Server Encyclopedia Public Interface Reference Guide.