DB2: Grant on a function
(1) see what role the user is in select substr(rolename,1,18) as rolename, substr(grantee,1,18) as grantee from syscat.roleauth order by rolename, grantee with ur; (2) run the GRANT grant execute on function WCS.CATEGORY_FILTER to role tibco; (3) what functions are on the database select funcname, specificname from syscat.functions where funcschema ='WCS' and funcname like 'TMW%'; (4) to see the privilege after extracting specificname from query (3) above. select * from SYSCAT.ROUTINEAUTH where specificname='SQL240417130406053';