October 25, 2005 at 1:36 pm
We have a security issue with temp tables in MS Access front end and SQL Server 2000 back end.
Depending on the user input parameters, it dynamically creates a temp table on the client side. In order for these temp tables to run, we have had to give them System adminsitrator server role. I have tried every conceivable combination of permissions and the only way it works is to give the users Sys Admin permissions. Obviously, I do not want them to have Sys admin role.
I have googled and have not found any information on this...anyone have an idea?
In time all of this will be put into stored procedures, right now it is not possible as there are hundreds of these procedures being ran. (this application was built long before I came into the picture)
Thanks in advanced!
October 26, 2005 at 2:53 am
can you give them access to the data via a view instead of the table directly?
you might be able to do something with that!
martin
October 26, 2005 at 5:32 am
hi,
i'm not quite clear on the location of the temp table. Is it a sql server temp table, created by the application, or is it a access temp table, created by ms access in ms access?
In the first case you might create a normal table and add the current SPID of the user to each record.
In the second case you might use an procedure that internally uses the sysadmin to create the table.
regards karl
Best regards
karl
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply