/*Find all stored procedure using a table*/ SELECT GRANTOR, GRANTEE, SELECTAUTH, INSERTAUTH, UPDATEAUTH, DELETEAUTH FROM SYSIBM.SYSTABAUTH WHERE GRANTEE LIKE 'SP_Prefix%' AND TTNAME LIKE '%table_name%' AND GRANTOR IN ('table_schema') ORDER BY GRANTEE ASC