Unanswered: Temp Tables and Restricted Permissions
I have a database that serves data to two websites. Site 1 is an admin site - used to update data. Site 2 displays data from one table in the DB. I want to be able to use a different login id for each site, (say login1 and login2) specifically so that site 2 only has access to the table from which it is displaying data.
I can set these permissions no problems, however the code on site 2 (an ASP site) creates a temp table when generating it's dataset. If I give login2 access to the specific table only, then I get an error on my web page telling me I dont have access to the temp table.
Is there a way around this? or do I have to give login2 access to the entire database?