Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.