Bookshelf Home | Contents | Index | Search | PDF

Siebel Server Installation Guide for Microsoft Windows > Installing the Siebel Database Server for Oracle > Database Server Installation on Oracle >

Creating Tableowner and Administrator Accounts for DB Server on Oracle

---

Your database administrator must execute the grantusr.sql script against your database server to create the Siebel tableowner (default: SIEBEL), Siebel administrator (default: SADMIN), and LDAPUSER accounts, and the role SSE_ROLE. Your database administrator must execute this script before configuring the Siebel Database Server.

This script is located in the DBSRVR_ROOT\DBSRVR_PLTFRM_ROOT subdirectory (in this case, Oracle) of your Siebel root directory.

This script performs the following functions:

Creates the role SSE_ROLE and grants "create session" privilege to this role.
Creates the user SIEBEL (the Siebel tableowner) and grants SSE_ROLE, RESOURCE, and other appropriate privileges to SIEBEL.
Creates the users SADMIN and LDAPUSER and grants the role SSE_ROLE to them.

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.

CAUTION:  Do not change the name of the Siebel administrator account, SADMIN. This account must be created for you to log onto Siebel eBusiness Applications as the Siebel administrator.

Tableowner and Administrator Account for Siebel Marketing

If you are planning to use Siebel Marketing, grant drop table, drop index, create table, and create index rights at the database level within the OLTP schema to the tableowner or the database userid used for Siebel Marketing. 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:

@c:\SIEBEL_ROOT\dbsrvr\oracle\grantusr.sql

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

Type the tablespace name listed in Deployment Planning Worksheets.

Bookshelf Home | Contents | Index | Search | PDF