search cancel

Does PPADB2 allow users to bypass DB2 security?

book

Article ID: 21300

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction

Question: 

Does PPADB2 allow users to bypass DB2 security?

Answer: 

PPA does not permit users the ability to bypass DB2 security. In PPA user guide chapter 2 Operational considerations, we discuss the plan authorizations as an additional layer of security, but in addition a user must possess the following authorization to update the catalog.

You can update the DB2 catalog statistics using the Plan Analyzer Catalog statistics facility when you have at least one of the following:

* SYSADM authority
* UPDATE authority on the catalog table or column being updated

Environment

Release:
Component: PPADB2