DB2 Version 9.7 for Linux, UNIX, and Windows

Authorization for administrative views

For all administrative views in the SYSIBMADM schema, you need SELECT privilege on the view. This can be validated with the following query to check that your authorization ID, or a group or a role to which you belong, has SELECT privilege (that is, it meets the search criteria and is listed in the GRANTEE column):

SELECT GRANTEE, GRANTEETYPE
   FROM SYSCAT.TABAUTH
   WHERE TABSCHEMA = 'SYSIBMADM' AND TABNAME = '<view_name>' AND
   SELECTAUTH <> 'N'

where <view_name> is the name of the administrative view.

With the exception of SYSIBMADM.AUTHORIZATIONIDS, SYSIBMADM.OBJECTOWNERS, and SYSIBMADM.PRIVILEGES, you also need EXECUTE privilege on the underlying administrative table function. The underlying administrative table function is listed in the authorization section of the administrative view. This can be validated with the following query:

SELECT GRANTEE, GRANTEETYPE
   FROM SYSCAT.ROUTINEAUTH
   WHERE SCHEMA = 'SYSPROC' AND SPECIFICNAME = '<routine_name>' AND
   EXECUTEAUTH <> 'N'

where <routine_name> is the name of the underlying administrative table function as listed in the documentation.

Some administrative views require additional authorities beyond SELECT on the view and EXECUTE on the underlying administrative table function. Any additional authority required is documented in the reference information describing the view.