CA Datacom SQL Security › Implementing the SQL Security Model › Adding View Security Authorizations › Adding a Default View Security Specification

Adding a Default View Security Specification

To add a default view security specification to the SYSIN parameters of your MUF startup JCL, add a comma followed by the word YES or NO to the SQLOPTION statement so that the new specification occupies the fifth position in the comma-separated list. For example:

 SQLOPTION YES,17,DATACOM,120,YES

The first YES specifies that SQL is to be enabled for use. The 17 specifies that the SQL Temporary Table Manager is in database ID 17. The DATACOM specifies the default for the SQLMODE= value in the SQL Preprocessor plan option. The 120 is the default LUW TIMEOUT specification. The next parameter, YES, specifies that view security is to be used for all plans that do not have an explicit VIEWSEC= specification.

Note: For more information, see the CA Datacom/DB Database and System Administration Guide.