HDFS execute permission
Posted: Tue Aug 20, 2013 9:33 am
Hello,
I have installed Hdfs conenctor into Vertica to be able to create external tables or load data from Hadoop into Vertica.
For that, I used following statements:
Everything works fine for user dbadmin.
Now I need to grant exec rights to normal users.
Hdfs source is visible when listing procedures with
But all my tries to grant exec failed.
What I've tried:
Any help appreciated.
Regards,
JB
I have installed Hdfs conenctor into Vertica to be able to create external tables or load data from Hadoop into Vertica.
For that, I used following statements:
Code: Select all
-- Installation script: defined the shared library and the appropriate entry points
select version();
\set libfile '\'/opt/vertica/packages/hdfs_connectors/lib/libvertica_hdfs_conn.so\'';
CREATE LIBRARY HdfsSource as :libfile;
CREATE SOURCE Hdfs as language 'C++' name 'HdfsFactory' library HdfsSource;Now I need to grant exec rights to normal users.
Hdfs source is visible when listing procedures with
Code: Select all
\df
List of functions
procedure_name | procedure_return_type | procedure_argument_types
---------------------------------------------------------+------------------------+---------------------------------------------------------------------------------
Hdfs | |
What I've tried:
Code: Select all
grant execute on procedure hdfs to username;
grant execute on procedure hdfs() to username;
grant execute on procedure hdfs(url Varchar, username Varchar) to username;Regards,
JB