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:
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.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. 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:
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.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.