DB2 UDF Permissions
- by WernerCD
I have a custom function that I'm working on... the problem I'm having is simple: Permssions.
example function:
drop function circle_area
go
CREATE FUNCTION circle_area (radius FLOAT)
RETURNS FLOAT LANGUAGE SQL
BEGIN
DECLARE pi FLOAT DEFAULT 3.14;
DECLARE area FLOAT;
SET area = pi * radius * radius;
RETURN area;
END
GO
if I then log out of my "admin" account... and log into test account I get a "Not authorized" error when I try to run something "Select circle_area(foo) from library.bar".
I can log into iSeries Navigator, navigate to schema functions permissions and change the permission for public from Exclude to All. bam it works.
How do I grant permission to all, either in the CREATE FUNCTION or after?
