pyodbc read only connection.

[Orianh]

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!

[Hubert-Dudek · Accepted solution]

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

[Orianh]

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

But wanted to ask just to be sure.!