How to use function
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.
Best Answer
-
mosheg Employee
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
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
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.