ODBC connected to SQL server, but can not qurey?
lazarus / 16-Databases

----------------------------------------------------------------------
Jonvy · 2019-05-25 05:44

Hi,
I use SQLdb ODBC connected to SQL database, but when I run qurey, I
get the following error:
select permission was denied. See attchment

What's the reason for this problem?

----------------------------------------------------------------------
zeljko · 2019-05-25 07:14

You have not enough permissions to query that table/view.

----------------------------------------------------------------------
Jonvy · 2019-05-25 07:32

Quote from: zeljko on May 25, 2019, 09:14:30 amYou have not enough
permissions to query that table/view.

I want to know which connection string I should add so I can have the
permissions to query?
Because I use the same account sql_admin,this is the super use
account,has permission both read and write. When I use microsoft Azure
Data Studio, it can view and modify all tables.