topic Re: pyodbc read only connection. in Data Engineering

pyodbc read only connection.

Orianh — Mon, 02 May 2022 13:03:18 GMT

Hey Guys,

Is there a way to open pyodbc read only connection with simba spark driver?

At the moment, I'm able to execute queries such as select , delete, insert into - basically every sql statement using pyodbc.

I tried to open pyodbc connection but only with read permissions which means the user won't be able to delete/ create/ change any table - just read data from it. but didn't succeed.

I tried open connections in this way:

con  = pyodbc.connect(connection_string, autocommit=True, readonly=True)

Is there a built in way already? Or I must check the query that i have been asked to execute?

Hope you can help me,

Thanks!

Re: pyodbc read only connection.

Hubert-Dudek — Tue, 03 May 2022 14:50:05 GMT

This readonly=True is working only on some drivers. Just create additional users with granted read-only permission.

Re: pyodbc read only connection.

Orianh — Tue, 03 May 2022 15:04:34 GMT

Thanks, I saw in pyodbc issues that not all drivers support it too.

But wanted to ask just to be sure.!