Siebel Installation Guide for Microsoft Windows > Installing the Siebel Database on the RDBMS > Creating Table Owner and Administrator Accounts >
Running the grantusr.sql Script on IBM DB2
Before you install the Siebel database, your DBA must manually create the Siebel table owner account, the Siebel administrator account (default: SADMIN), and the SSE_ROLE group. The DBA must then add the Siebel administrator account to the SSE_ROLE group at the operating system level.
Before you install the Siebel database, execute the grantusr.sql script against your database server to grant the appropriate privileges to these users. The grantusr.sql script is located in the
Your DBA must review and execute this script, which performs the following functions:
- Grants DBA administration (DBADM) privileges to the table owner account.
- Grants CONNECT privileges to the SSE_ROLE group.
You cannot create the LDAPUSER account by running grantusr.sql. This account must belong to the SSE_ROLE group and be created by the DBA or the Windows network administrator, as appropriate. For more information about authentication using the LDAP security adapter, see Siebel Security Guide.
This topic is part of Creating Table Owner and Administrator Accounts.
To run the grantusr.sql script on IBM DB2
- Execute the grantusr.sql script from a DB2 Command Window, using an account with DBA privileges.
The usual DB2 System Administration account is called
db2admin for this procedure.
CAUTION: Use the DB2 Command Window, not the Command Line Processor, to enter these commands, because the Command Line Processor window uses different syntax. The commands in this procedure must be issued in a DB2 Command Window.
- Enter the following commands:
db2 connect to
- Enter the tablespace name that you recorded in the copy that you made of Siebel Deployment Planning Worksheet and exit the script.
The length and allowable characters of the account names and passwords depend on the rules of your underlying RDBMS platform. For more information, see IBM DB2 documentation.
Before you install the Siebel database, see Installing the Stored Procedures and User-Defined Functions on IBM DB2.