USE PROTECTION field (AUTH subsystem parameter)
The AUTH subsystem parameter controls whether Db2 is to check authorizations.
| Acceptable values: | YES, NO |
|---|---|
| Default: | YES |
| Update: | option 38 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM AUTH |
| Security parameter: | Security-related |
- 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: This 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.