Implementing Siebel Business Applications on DB2 UDB for z/OS > Security Concepts for z/OS > Data Transmission Security for Siebel Clients >
Granting SELECT Authority to Access the DB2 Catalog
Siebel Business 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 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
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;
|