Running the grantuser.sql Script

A database administrator, who may or may not be a direct member of the Siebel development team, performs these steps.

After preparing the database, run the grantusr.sql script found in the .../dbsrvr/{db_platform} folder (for example, C:\Siebel\ses\dbsrvr\ORACLE). There are brief instructions at the beginning of each script explaining how to run the script. It will prompt you for information about the preparatory work done in the previous step, for example. the server where the database resides, the name of the database, any tablespaces, usernames, passwords, and so on. When the script completes, you will have an empty shell of a Siebel database with all the required users. Note that the execution of the script is typically done by a database administrator who may or may not be a direct member of the Siebel development team. This allows the Siebel team to have everything they need to populate the Siebel CRM Database without the need for specialized database administrator skills. The Siebel team should provide the desired passwords for the database users that the script will create. These include:

• SADMIN. The Siebel Administrator user will be used for administering the Siebel CRM application throughout the implementation.

• GUESTCST. The anonymous Guest Customer user. This user's credentials are used automatically by customer-facing applications before a user has actually logged in, providing access to the login page itself. This allows access to non-sensitive areas of the product, such as Branch Locators, without the need for every visitor to have a login.

• GUESTERM. The anonymous Employee user. This user's credentials are used automatically by employee-facing applications before a user has actually logged in.

• LDAPUSER. This is a generic user used by the authentication system.

After the script has been executed, test the SADMIN login using a database platform-specific tool, such as SQL*Plus for Oracle, to verify that the user was correctly created.