DB2 10.5 for Linux, UNIX, and Windows

Authorizations for using built-in routines and views

All built-in routines and views require specific privileges to run.

Built-in routines

For all built-in routines in the SYSPROC schema, you need EXECUTE privilege on the routine. You can use the following query to check whether your authorization ID, or a group or a role to which you belong, has EXECUTE privilege:

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

where routine_name is the name of the built-in routine.

If your authorization ID, or a group or a role to which you belong, is listed in the GRANTEE column, then you have access to the specified built-in routine.

Built-in views

For all built-in views in the SYSIBMADM schema, you need SELECT privilege on the view. You can use the following query to check whether your authorization ID, or a group or a role to which you belong, has SELECT privilege:

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

where view_name is the name of the built-in view.

If your authorization ID, or a group or a role to which you belong, is listed in the GRANTEE column, then you have access to the specified built-in view.