When using an asp page to access a SQL Server 6.5 I get a response of
EXECUTE Permission Denied.
This occures when I try to open a recordset.
RS.Open "tablename", conn, 3,3
Its weird, I gave the user full access to select, insert etc but i get the
execute permission denied message. I only see an execute permission for
stored procedures, not tables.
If I hardcode it to use the sa account it works. As far as I can tell Ive
given this user all the permissions I can. Would this user need any access
to the other tables ie. master etc??