If you will use the Oracle SQLPLUS utility to perform queries against the CSE databases, you will need to access the database with the following statement:
sqlplus <userid>/<password>
where:
<userid> is the Oracle userid for the Encyclopedia Database Administrator.
<password> is the Oracle password for the Encyclopedia Database Administrator.
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 user ID 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 user IDs in the Encyclopedia database (with connect authority), to grant these userids select access to views, and to create public synonyms.
Note: For more information, see the CA Gen Client Server Encyclopedia Public Interface Reference Guide.
|
Copyright © 2013 CA.
All rights reserved.
|
|