ODBC Error

[rixter67]

Help please, I have an ASP page that updates a SQL database. When a remote user tries to log in and update the following error message appears:

Microsoft OLD DB Provider for ODBC Drivers error '80040e09'

[Microsoft] [ODBC SQL Server Driver] [SQL Server} SELECT Permission denied on object 'USERS', database xxxx, owner xxxx.

What is going wrong here? Is it that the database permissions are not set to select and write to the database???

 

[SashiRaveendran]

you have to set up permissions on your tables, you can do this from enterprise manager if you have it

 

[rixter67]

That would mean the Users table is a good place to start, correct?