I've creating a few user-defined function on the AS400. They run fine for me, but if anyone else tries to use them, they get an error message telling them they are not authorized to use them. How do I create a udf that other users have the authority to access?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
setting the permissions on a user-defined function 1
- Thread starter ddiamond
- Start date
-
1
- #2
gregsimpson
Programmer
- Apr 18, 2002
- 521
ddiamond,
I think you treat it like any other db object and need to do a grant. I believe the following will do the job.
GRANT EXECUTE ON SPECIFIC FUNCTION ddiamondsUDF TO PUBLIC
Cheers
Greg
I think you treat it like any other db object and need to do a grant. I believe the following will do the job.
GRANT EXECUTE ON SPECIFIC FUNCTION ddiamondsUDF TO PUBLIC
Cheers
Greg
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question