The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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

yamakawayamakawa 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.

Best Answer

Answers

  • yamakawayamakawa Vertica Customer

    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