I ran sqlline with user "kuser1".
I tried to access a file that is only accessible by root:
I am able to read the table, which should not be possible. I used this commit for Drill 1.15.
This is from drillbit.log. It shows that user is kuser1.
It is not clear to me if this is a Drill problem or a file system problem. I tested MFS by logging in as kuser1 and trying to copy the file using "hadoop fs -copyToLocal /drill/testdata/impersonation/neg_tc5/student" and got an error, and was not able to copy the file. So I think MFS permissions are working.
I also tried with Drill 1.14, and I get the expected error:
The commit for Drill 1.14 is:
This problem exists with both Apache JDBC and Simba ODBC.
Here is drill-distrib.conf. drill-override.conf is empty. It is the same for both 1.14 and 1.15.