Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Security Concepts for z/OS and OS/390 > Data Transmission Security for Siebel Clients >

Granting SELECT Authority to Access the DB2 Catalog

Siebel eBusiness Applications access the DB2 catalog to validate installation inputs.

To grant appropriate users access privileges to the DB2 catalog, the system administrator must grant SELECT authority on certain catalog tables to users of the Siebel Database and to users of the installation or upgrade utility.

• Siebel Database users (also known as privileged users who make changes to the Siebel database) require SELECT authority for SYSIBM.SYSTABLES.
• Database Server installation or upgrade users require SELECT authority for the following tables:

  SYSIBM.SYSAUXRELS

  SYSIBM.SYSCOLUMNS

  SYSIBM.SYSDATABASE

  SYSIBM.SYSINDEXES

  SYSIBM.SYSKEYS

  SYSIBM.SYSROUTINES

  SYSIBM.SYSSTOGROUP

  SYSIBM.SYSTABLESPACE

  SYSIBM.SYSTABLES

  SYSIBM.SYSTABLEPART

  SYSIBM.SYSTRIGGERS

To grant SELECT authority to access the DB2 Catalog

• Use the following command:

  GRANT AUTHORITY_TYPE ON TABLE TABLENAME TO USER;

  For example, to grant SELECT authority on the table SYSIBM.SYSTABLES to SSEROLE, use the following command:

  GRANT SELECT ON TABLE SYSIBM.SYSTABLES TO SSEROLE;

Granting UPDATE Authority to Update DB2 Catalog Statistics

NOTE:  Updating DB2 catalog statistics is optional.

To give appropriate users the authority to update catalog statistics using the loadstat.sql script, the system administrator must grant UPDATE authority to installation or upgrade users for the following tables:

SYSIBM.SYSCOLUMNS

SYSIBM.SYSINDEXES

SYSIBM.SYSINDEXSTATS

SYSIBM.SYSKEYS

SYSIBM.SYSTABLES

SYSIBM.SYSTABLESPACE

SYSIBM.SYSTABSTATS

The loadstat.sql script is provided in the dbsrvr/DB2390 directory, which is created during the database server installation. For information on using this script, see Loading Statistics.