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
), andLDAPUSER
accounts, and the roleSSE_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 grantsSSE_ROLE
,RESOURCE,
and other appropriate privileges toSIEBEL
.- Creates the users
SADMIN
andLDAPUSER
and grants the roleSSE_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 thegrantusr.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.sqlNOTE: 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 |
Siebel Server Installation Guide for Microsoft Windows Published: 25 June 2003 |