How to use function
yamakawa
Vertica Customer ✭
Hi.
Sorry for the rudimentary question.
A user-defined function created by the DB administrator is passed to the
What do I need for general users to use it?
Anyway "alter function myfunction () owner to user;"
It's now available in, but I don't think it's a fundamental solution.
Thank you for your reply.
Tagged:
0
Best Answer
-
mosheg Vertica Employee Administrator
To see how to grant privileges on user-defined extension (UDx) to users and roles read this: https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/SQLReferenceManual/Statements/GRANT/GRANTUserDefinedExtension.htm
Please also verify that the granted user session include a PATH to your function Schema:
SHOW SEARCH_PATH;
And if needed: SET SEARCH_PATH to YOUR_FUNCTION_SCHEMA_NAME, public;5
Answers
Thank you for an immediate answer.
Run the following command to make sure that user-defined functions are available to the general user.
@dbadmin
create fuction test_func() return date as begin ...end;
grant execute on function test_func() to public;
@general user
select test_func();
That's all, thank you.