Separate security administration from system administration

Méthode de vérification

Méthode d'audit: Revue manuelle

Cette recommandation ne peut pas être vérifiée automatiquement. Une analyse la liste avec ces instructions lorsque vous passez --include-manual.

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

Méthode de correction

Méthode de correction: Recommandation ou correctif d'infrastructure

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.