Example 1: Allowing access (auditing for failures)
RACF access control module can grant access to Db2 objects based on a Db2 administrative authority profile.
This example shows how the RACF access control module allows access to a Db2 object (a table) based on a Db2 administrative authority profile. Auditing is activated for failures.
In this example, user ID MIKEJ is trying to alter a table called BDA0828.EMP in database JBW2000.
Setup
- Classification model (
&CLASSOPT):2 - Class name root (
&CLASSNMT):DSN - Class name suffix (
&CHAROPT):1This is the default value, but it is not used with supplied classes.
- Db2 subsystem name:
VHH1 - Profiles:
- Defined in the MDSNTB class:
VHH1.BDA0828.EMP.ALTERAUDIT(FAILURES(READ))UACC(NONE)
- Defined in the DSNADM class:
VHH1.SYSADMAUDIT(FAILURES(READ))UACC(NONE)ID(MIKEJ) ACCESS(READ)
- Defined in the MDSNTB class:
- User ID MIKEJ has SYSADM authority.
Profile checking
RACF checks the following resources:
- VHH1.BDA0828.EMP.ALTER
in class MDSNTB
Results:
- Access is denied (return code 8).
- No failure message (ICH408I) is issued.
- No audit records are created.
- VHH1.JBW2000.DBADM in class DSNADM
Results:
- No profile is found (return code 4).
- No failure message (ICH408I) is issued.
- No audit records are created.
- VHH1.SYSADM in class DSNADM
Results:
- Access is granted (return code 0).
- No failure message (ICH408I) is issued.
- No audit records are created.
Final result
The RACF access control module sends a return code of 0 to Db2.