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
sdac5pro
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?

AndreyZ

Post by AndreyZ » Thu 16 Jun 2011 11:44

Hello,

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:
http://social.msdn.microsoft.com/forums ... b9c04032c/
http://www.sqlservercentral.com/Forums/ ... 146-1.aspx

Post Reply