Granting Table Privileges

This task is a step in the Process of Completing the Siebel Database Implementation.

To grant the Siebel group ID additional, required privileges on EIM tables, the database administrator must edit and execute the grantstat.sql file. This procedure is described in this topic.

To edit and run the grantstat.sql script

1. Navigate to the grantstat.sql script which is located in the DBSRVR_ROOT\db2390 directory (Windows) or the DBSRVR_ROOT/db2390 directory (UNIX).

2. Edit grantstat.sql by replacing &1 with the Siebel Schema Qualifier ID that you recorded in Deployment Planning Worksheet.

3. Execute the grantstat.sql script, using the method you prefer.