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';