Separate security administration from system administration

Nasıl denetlenir

Denetim yöntemi: Manuel inceleme

Bu öneri otomatik olarak denetlenemez. --include-manual parametresini verdiğinizde tarama bunu bu talimatlarla birlikte listeler.

Run the DSNTEJ6Z job to obtain the current value of the SEPARATE_SECURITY subsystem parameter. Verify that the value is set to YES.

Nasıl düzeltilir

Düzeltme yöntemi: Kılavuz veya altyapı yaması

1. Ensure that the current SQLID is one of the authorization IDs of the process for applications that use SYSADM authority to set current SQLID. 2. Ensure that the binder has BINDAGENT privilege from the owner for the bind and rebind processes that use SYSADM, SYSCTRL, or system DBADM authority to specify the OWNER keyword. 3. Edit the DSNTIJUZ job and set the DSN6SPRM.SEPARATE_SECURITY parameter to YES. 4. Submit DSNTIJUZ to assemble the subsystem parameter. 5. Either issue the -SET SYSPARM command or stop and restart Db2 to activate the changes.