Running the grantusr.sql Script on Microsoft SQL Server

Before you install the Siebel database, your DBA must review, modify, and execute the grantusr.sql script. This task is part of Creating Table Owner and Administrator Accounts.

The administrator executes grantusr.sql against the database to set up minimum security. The grantusr.sql script is located in the DBSRVR_ROOT\MSSQL subdirectory.

The grantusr.sql script performs the following functions:

• Creates database accounts (logins) for the SADMIN (Siebel administrator) account, the table owner account, and the LDAPUSER account.

• Creates users for each of these accounts, except the table owner account, which will be turned into a dbo by the stored procedure sp_changedbowner.

• Grants SSE_ROLE to each account, except dbo.

To change the account name or the database name, edit grantusr.sql. The length and allowable characters of the account names and passwords depend on the rules of your underlying RDBMS platform. For more information, see Microsoft SQL Server documentation.

To run the grantusr.sql script on Microsoft SQL Server

1. Open grantusr.sql in Microsoft Query Analyzer.

2. Execute the script.