Bookshelf Home | Contents | Index | Search | PDF |
Siebel Server Installation Guide for Microsoft Windows > Installing the Siebel Database Server for DB2 UDB > Database Server Software Installation for DB2 >
Creating Tableowner and Administrator Accounts on DB2
Your database administrator must manually create the Siebel tableowner account (default:
SIEBEL
), the Siebel administrator account (default:SADMIN
), and theSSE_ROLE
group. The database administrator must then add the Siebel administrator account to the
SSE_ROLE
group at the operating system level.Execute the
grantusr.sql
script against your database server to grant the appropriate privileges to these users. Thegrantusr.sql
script must be run before you configure the Siebel Database Server.This script is located in the
DBSRVR_PLTFRM_ROOT
subdirectory (for example,sea7.x.x\dbsrvr\DB2UDB
). Your database administrator should review and run this script, which performs the following functions:
- Grants DBA administration (
DBADM
) privileges to tableownerSIEBEL
.- Grants
CONNECT
privileges to theSSE_ROLE.
NOTE: You cannot create the
LDAPUSER
account by runninggrantusr.sql.
This account must belong to theSSE_ROLE
group and be created by the database administrator or the NT/2000 network administrator, as appropriate. For more information about LDAP security adapter authentication, see Security Guide for Siebel eBusiness Applications on Siebel Bookshelf.
CAUTION: Do not change the name of the Siebel administrator account,
SADMIN.
This account must be created for you to log onto Siebel 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
- Execute the
grantusr.sql
script from a DB2 Command window, using an account with DBA privileges.The usual DB2 System Administration account will be called db2admin for this procedure.
CAUTION: Be sure to use the Command window, not the Command Line Processor to enter these commands, since the Command Line Processor window uses different syntax. These commands will, therefore, not work unless issued in a Command Window.
- Enter the following commands:
db2 connect to DB2database Alias user
Instance Owner Username using passworddb2 -vf
SIEBEL_ROOT
\dbsrvr\db2udb\grantusr.sqlwhere:
DB2database Alias =
the DB2 alias you use.
Instance Owner Username
= the login ID of the instance owner.
password
= password for the database instance (length and allowable characters depend on the rules of your underlying RDBMS platform).
SIEBEL_ROOT =
your Siebel root directory.- Enter the tablespace name you recorded in the copy you made of Deployment Planning Worksheets then exit.
Before starting configuration, proceed to Installing the Stored Procedures and User-Defined Functions on DB2.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Server Installation Guide for Microsoft Windows Published: 25 June 2003 |