Separate security administration from system administration

Kako se proverava

Metod provere: Ručni pregled

Ova preporuka se ne može proveriti automatski. Skeniranje je navodi sa ovim uputstvima kada prosledite --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.

Kako se ispravlja

Metod ispravke: Smernica ili zakrpa infrastrukture

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.