Recent

Author Topic: ODBC connected to SQL server, but can not qurey?  (Read 806 times)

Jonvy

  • Jr. Member
  • **
  • Posts: 90
ODBC connected to SQL server, but can not qurey?
« on: May 25, 2019, 07:44:25 am »
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

  • Hero Member
  • *****
  • Posts: 1594
    • http://wiki.lazarus.freepascal.org/User:Zeljan
Re: ODBC connected to SQL server, but can not qurey?
« Reply #1 on: May 25, 2019, 09:14:30 am »
You have not enough permissions to query that table/view.

Jonvy

  • Jr. Member
  • **
  • Posts: 90
Re: ODBC connected to SQL server, but can not qurey?
« Reply #2 on: May 25, 2019, 09:32:34 am »
You 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.



 

TinyPortal © 2005-2018