USE PROTECTION field (AUTH subsystem parameter)

The AUTH subsystem parameter controls whether DB2® is to check authorizations.

Acceptable values: YES, NO
Default: YES
Update: Start of changeoption 24 on panel DSNTIPBEnd of change
DSNZPxxx: DSN6SPRM AUTH
Start of changeSecurity parameter:End of change Start of changeYesEnd of change
YES
Enables authorization checking in DB2.

If you specified YES for the value of CACHE DYNAMIC SQL on panel DSNTIP8, you must also specify YES for this value.

Recommendation: Specify YES.

NO
Disables all authorization checking in DB2 and disables the GRANT statement. In this case, every privilege is granted to PUBLIC.
Note: Start of changeThis is a security-related parameter. If it is set to NO, individual grants cannot be performed and all privileges are granted to PUBLIC, which allows any user to access user data.End of change