Granting SELECT Authority to Access the DB2 Catalog

Siebel CRM accesses 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 database installation utility, as follows:

• Siebel database users (also known as privileged users who make changes to the Siebel database) require SELECT authority for SYSIBM.SYSTABLES.

• Database installation users require SELECT authority for the following tables:

  • SYSIBM.SYSAUXRELS

  • SYSIBM.SYSCOLUMNS

  • SYSIBM.SYSDATABASE

  • SYSIBM.SYSINDEXES

  • SYSIBM.SYSINDEXPART

  • SYSIBM.SYSKEYS

  • SYSIBM.SYSROUTINES

  • SYSIBM.SYSSTOGROUP

  • SYSIBM.SYSTABLESPACE

  • SYSIBM.SYSTABLES

  • SYSIBM.SYSTABLEPART

  • SYSIBM.SYSTRIGGERS

  The following procedure describes how to grant SELECT authority to access the DB2 catalog.

To grant SELECT authority to access the DB2 Catalog

• Use this 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;