SELECT problem

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 1
Joined: Tue 14 Jun 2011 19:22
Location: The Netherlands

SELECT problem

Post by sdac5pro » Wed 15 Jun 2011 18:05

I have SDAC 5 for Delphi 5. When I try to open a database (open application then open a table) I get the following error:

"SELECT permission denied on object 'InOut', database ComplaintSQL1', owner 'dbo'"

I have gone into the SQL database and given all domain users select, and update on the table in question. What else do I have to do?


Post by AndreyZ » Thu 16 Jun 2011 11:44


Please try granting the SELECT right to the user that you are using to connect to SQL Server in the following way:

Code: Select all

GRANT SELECT ON InOut TO "username"
If it doesn't help, please take a look at the following links: ... b9c04032c/ ... 146-1.aspx

Post Reply