Solved: UDF bucket permissions

SQL-Fighter

I'm able to secure and upload/download jars using bucket permissions:

https://docs.exasol.com/database_concepts/bucketfs/file_access.htm

However, I am having trouble running a java UDF without "public" permissions on the bucket.  When it's not public, the engine says that it can't find the jar file.  Assuming the UDF port is protected, this is not an issue.   

 

 

1 ACCEPTED SOLUTION

SQL-Fighter

Ok, so here's the answer:

 

CREATE CONNECTION my_bucket_access TO 'bucketfs:bfsdefault/bucket1'
  IDENTIFIED BY 'readpw';

GRANT CONNECTION my_bucket_access TO my_user

 

View solution in original post

1 REPLY 1

SQL-Fighter

Ok, so here's the answer:

 

CREATE CONNECTION my_bucket_access TO 'bucketfs:bfsdefault/bucket1'
  IDENTIFIED BY 'readpw';

GRANT CONNECTION my_bucket_access TO my_user

 

View solution in original post