Implementing Siebel Business Applications on DB2 UDB for z/OS > Siebel Repository Import and Postinstallation Tasks > Postinstallation Tasks for the Siebel Repository >

Granting Table Privileges

The database administrator edits and executes the file, grantstat.sql, located within the DBSRVR_ROOT\db2390 directory (Windows) or the $DBSRVR_ROOT/db2390 directory (UNIX), to grant the Siebel group ID additional, required privileges on EIM tables.

To edit and run the grantstat.sql script

1. Locate the grantstat.sql script and edit it by replacing &1 with the Siebel Schema Qualifier ID that you recorded in Deployment Planning Worksheet.
2. Substitute &2 with the security group ID, or with another user ID.
3. Execute the grantstat.sql script using the method you prefer.

NOTE:  If you use multiple security groups, grant this privilege to each group.