Bookshelf Home | Contents | Index | Search | PDF

Siebel Server Installation Guide for UNIX > Installing the Siebel Database Server for Oracle > Database Server Installation on Oracle >

Creating Tableowner and Administrator Accounts for DB Server on Oracle

---

The Oracle database administrator must manually create the tableowner account (default: siebel), the Siebel Administrator account (default: sadmin), and the sse_role group. You must then add the two accounts to the sse_role group.

NOTE:  On Solaris, the sse_role group cannot be created using the admintool due to the use of an underscore in the name. Instead, use the command groupadd sse_role to create the sse_role group and ignore the UX: groupadd: sse_role name should be all lower case or numeric warning.

Execute the grantusr.sql script against your Siebel Database Server to grant the appropriate privileges to these users. The grantusr.sql script must be run before you run the Database Server Configuration Wizard to create the Siebel database schema.

This script is located in the $DBSRVR_PLTFRM_ROOT subdirectory. Your database administrator should review and run this script, which performs the following functions:

Grants the appropriate permissions to the Siebel tableowner account that will "own" all the database objects for your Siebel deployment.
Creates a role (sse_role) with create session privileges for SADMIN, SIEBEL, and LDAPUSER.

CAUTION:  Do not change the name of the Siebel Administrator Account, SADMIN. This account must be created for you to log on to Siebel as the Siebel Administrator.

The default user name and password for the logon are listed in the grantusr.sql script. If you want another logon, edit the grantusr.sql script and change all the references to your preferred name. However, keep in mind that the length and allowable characters for the login ID and password depend on the rules of your underlying RDBMS platform. See your Oracle documentation for instructions.

NOTE:  You should not use any numeric login IDs; otherwise, you will not be able to change password with Oracle database authentication.

Tableowner and Administrator Account for Siebel Marketing

The tableowner or the database User ID used for Siebel Marketing requires additional rights at the database level within the OLTP schema. You must grant drop table, drop index, create table, and create index rights to this user. For more details, see Siebel Marketing Guide.

To run the grantusr.sql script

Run the grantusr.sql script from SQL*Plus, using an account with DBA privileges, and using the following command:

@SIEBEL_ROOT/dbsrvr/oracle/grantusr.sql

NOTE:  You must specify the full path to the SIEBEL_ROOT directory.

The script prompts you for the default tablespace in which your Siebel objects are to be created.

Type the tablespace name you listed in Deployment Planning Worksheets.

Bookshelf Home | Contents | Index | Search | PDF