SELECT problem

[sdac5pro]

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]

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