External Security Considerations › Control Table Access Using SQL Resources or OPSGLOBAL

Control Table Access Using SQL Resources or OPSGLOBAL

Control access to specific tables under the SQL resources or specific variables under the OPSGLOBAL facility through the resources that are defined to your external security manager.

Prepare to use SQL or GLOBAL to control access to tables by running DEFSAF to get the resources defined to your external security manager as follows:

• Secure access to the CA OPS/MVS STCTBL by creating the resource name prefix.SQL.STCTBL for the SAF check. Permit access to the resource name by running DEFSAF as follows:

  TSO OX 'opshlq.CCLXEXEC(DEFSAF)' OPSSQL.STCTBL ACT(DEFINE) 
  TSO OX 'opshlq.CCLXEXEC(DEFSAF)' OPSSQL.STCTBL ACT(PERMIT) SAFRO(myuid) GROUPS(N)
  

• Secure access to a global variable named GLOBAL1 by creating the resource name prefix.OPSGLOBAL.GLOBAL1 for the SAF check. Run DEFSAF as follows:

  TSO OX 'opshlq.CCLXEXEC(DEFSAF)' OPSGLOBAL.GLOBAL1 ACT(DEFINE) 
  TSO OX 'opshlq.CCLXEXEC(DEFSAF)' OPSGLOBAL.GLOBAL1 ACT(PERMIT) SAFRO(myuid) GROUPS(N)
  

You are ready to use the SQL resources or the OPSGLOBAL facility.