Problem in executing the RIGHT function of SYSFUN schema

[gbag]

Hi ,
I have a problem in granting the privilegs to one of our users.
One of our users cannot execute the system functions like LEFT, RIGHT,etc of SYSFUN schema. When I tried to grant EXECUTE permission, I got the error as
[IBM][CLI Driver][DB2/AIX64] SQL0607N "GRANT OR REVOKE"
is not defined for system objects. SQLSTATE=42832

Now, I can neither grant the permission nor the user can use those functions. In such a situation, how can we allow
a user to execute this kind if functions. I don't want the
user to be ADMIN.
I feel that the an ordinary user should be able to execute these functions.

A help is highly appreciated.
Thanks

 

[gregsimpson]

gbag,

are you sure it's the functions they can't access, or is it the tables they are trying to use those functions on?

Cheers
Greg