|
|
Grant authority to DISPLAYAUTH group Class = DSNR
Profile = DB2SSID.BATCH with Authority READ
Profile = DB2SSID.DISPLAY with Authority READ
|
SubsystemPrefix DISPLAY GROUP
|
|
With native DB2 security:
Grant authority to DISPLAYAUTH group Class = DSNR
Profile = DB2SSID.BATCH with Authority READ With RACF / DB2 security:
Grant authority to DISPLAYAUTH group
Profile = DB2SSID.BATCH with Authority READ
Profile = DB2SSID.DISPLAY with Authority READ
|
SELECT * FROM SYSIBM.LOCATIONS; SELECT * FROM SYSIBM.SYSDATABASE; SELECT * FROM SYSIBM.SYSTABLESPACE;
|
|
With native DB2 security:
Grant authority to DISPLAYAUTH group Class = DSNR
Profile = DB2SSID.BATCH with Authority READ
With RACF / DB2 security:
Grant authority to DISPLAYAUTH group
Profile = DB2SSID.BATCH with Authority READ
Profile = DB2SSID.OWNER.TABLE.ACTION with
e.g.: Profile = DB2SSID.*.*.SELECT
or Profile = DB2SSID.SYSIBM.*.SELECT
DB2SSID.SYSIBM.LOCATIONS.SELECT
(access required must be granted to the most specific RACF
|