Error “insufficient privileges for using connection”

First of all, if you’d like to know how to setup a connection from scratch, please check out this post I wrote on setting up an SFTP connection in Exasol.

However, if you’ve just got the error “insufficient privileges for using connection”, chances are you forgot to grant permissions to some other user, who has tried to use this connection.

GRANT CONNECTION MY_SFTP_CONNECTION to ANOTHER_EXASOL_USER;

This will allow the user to use the connection in conjunction with any other database object they have permissions to use.

Leave a Reply