I am writing a web interface which uses a MSSQL Server 2000 database. I have checked and double checked all permissions and can't find any problems but when I run a
select * from sales
I get the 'Permission denied for `sales` database `dbasename` database owner `sqluser`
I connect with the string
and this connects fine, so I am attempting to select all the components from a table that the user I connect with owns. As a sideline, I can create tables, but cannot read them in any way.
Any advice would be appreciated.