Bookshelf Home | Contents | Index | PDF |
Siebel Security Guide > Changing and Managing Passwords > Changing the Table Owner PasswordThis 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 (alias TableOwner) 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 (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:
To change the password for the table owner account
|
Siebel Security Guide | Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |