exasol / pyexasol

Exasol Python driver with low overhead, fast HTTP transport and compression
MIT License
71 stars 39 forks source link

Why does the user need execute rights #69

Closed ageof closed 3 years ago

ageof commented 3 years ago

Why does the user need execute rights in your library if you only want to read data? If there is no good reason, the permissions should be read-only

littleK0i commented 3 years ago

Hello,

Could you enable debug=True connection option and attach logs?

Generally speaking, permissions do not depend on driver. Permissions depend on users / roles / grants, but driver has no way of overriding it or requesting something new.

It is true for all types of drivers: ODBC, JDBC, Pyexasol, etc.