Changing the Table Owner Password

This topic describes the steps to perform if you want to change the table owner password. Before you run the Database Configuration Wizard to configure the Siebel database on the RDBMS, you must create a database table owner (DBO) account with the appropriate permissions to modify the Siebel database tables. The table owner is used to reference table names in SQL statements that are generated by the Siebel application (for example, SELECT * FROM SIEBEL.S_APP_VER).

You create the database table owner account manually (on IBM DB2) or using the grantusr.sql script (Oracle or Microsoft SQL Server). For information on creating the table owner account, see the Siebel Installation Guide for the operating system you are using. Select a user ID for the table owner that meets your organization's naming conventions. Also specify a password for the database table owner account.

A corresponding parameter named Table Owner (see Table A-1) is configured for the Siebel Enterprise. Siebel application modules such as Application Object Managers use this parameter value to provide the table owner name when generating SQL for database operations. You specify the table owner name during Siebel Enterprise Server configuration, which provides a value for this parameter.

A related parameter is Table Owner Password (example alias: TableOwnPass). For most database operations performed for Siebel Business Applications, the table owner password does not have to be provided. For this reason, this parameter is not configured during Siebel Enterprise Server configuration. However, if the Table Owner Password parameter is not defined, then the table owner password might sometimes have to be provided manually.

Note the following requirements for changing the table owner password:

• If you have not defined the Table Owner Password parameter, then the table owner password only has to be changed in the Siebel database. (The changed password might also have to be provided manually for certain operations.)

• If you have defined the Table Owner Password parameter, then you must also update the value for this parameter when you change the password in the Siebel database.

To change the password for the table owner account  

1. Change the table owner password for the Enterprise as follows:

   1. Log into a Siebel employee application, such as Siebel Call Center.

   2. Navigate to the Administration - Server Configuration screen, then the Enterprises view.

   3. Click the Parameters tab.

   4. In the Enterprise Parameters list, locate the Table Owner Password parameter (alias TableOwnPass).

   5. In the Value field, type in the new value, then commit the record.

2. Change the password in the database.

   For more information on changing passwords, refer to your RDBMS documentation.

3. Restart the Siebel Server.