Implementing Siebel Business Applications on DB2 for z/OS > Security Concepts for a DB2 for z/OS Environment > Data Transmission Security for Siebel Clients >

Granting Authorization to Views in DB2

GRANT VIEW statements can fail on DB2 for z/OS if you use an external security manager, such as RACF, to protect DB2 resources, and if internal security authorizations are not also in place. Such failures might occur because when a GRANT VIEW statement is issued on DB2 for z/OS, DB2 only carries out internal database security checks before giving authorization to the view. If an internal security mechanism defining privileges to views does not exist, because these privileges are defined using an external security manager, the GRANT VIEW statement fails.

GRANT VIEW statements are issued only in the ddlview.sql file; this contains the DDL to create the Siebel Schema.