Tags

, , , , , , , ,

To know who all have access to a DB2 stored procedure, you can look at the system catalog table SYSIBM.SYSROUTINEAUTH. Query is provided below.

SELECT *
FROM SYSIBM.SYSROUTINEAUTH
WHERE SPECIFICNAME = ‘Your Procedure Name goes here’
WITH UR;

 

Advertisements