dollarbill
Programmer
I setup a user as db_datareader and db_datawriter. When I logon as that user it allows me to view the tables and query them in SQL Server. However, when I try to access one of the tables through a web I am creating with that user name and password, it gives me an error of "Invalid object name 'table'". If I change the table owner from my user which has db_owner permissions to the user setup with both sysadmin and db_owner permissions as the table owner it allows the new user I setup to access the table. Any ideas would be greatly appreciated.