If the Vertica database User is not having Execute permissions on ODBC, follow the below syntax to grant execute permissions. dbadmin (Super user) can give the permissions.
Syntax:
GRANT EXECUTE ON SOURCE public.ODBCSource() to <User Name>;
GRANT EXECUTE ON SOURCE public.ODBCLoader() to <User Name>;
I am trying this, and it works fine for ODBCSource(). For ODBCLoader() I am getting the following error:
ReplyDelete[Vertica][VJDBC](2059) ROLLBACK: Function with specified name and parameters does not exist: ODBCLoader
Any idea why this would not be working? I can execute as DBAdmin, but I am trying to get a couple of other users permission to execute.
Thanks!
If you are able to access ODBCLoader() from DBAdmin, then can you run the grant execute permission on all user define functions (please refer below attached link) first later try the above commands.
Deletehttp://verticadatabases.blogspot.in/2014/02/execute-permissions-on-user-defined.html