How DB2 Resource Checking works.

Document ID : KB000012786
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How does DB2 resource checking works to determine if a user is authorized for a DB2 resource?

Answer:

In an attempt to check for access to DB2 resources there are a number of checks issued which check for authorization from the lowest level to the highest. In the case of checking for LOAD access to a DB2TABLE the possible resource permissions which will allow access include:

1 ALL access to a DB2TABLE
2 LOAD access to a DB2TABLE
3 LOAD access to a DB2DBASE
4 DBCTRL access to a DB2DBASE
5 Access to DB2SYS(DATAACCESS)
6 Access to DB2SYS(SYSCTRL)
7 Access to DB2SYS(SYSADM)

The above checks will be issued in order. If the results of any of those checks allows access then the load will be allowed.