When I create a temporary table in a multi-user environment do all users see / have access to the table?
If the answer is yes, is there a way to replicate / spoof a temp table? I need to create a temp table based upon a specific users 'search' criteria. I was thinking about using the netuser function to get the user name and load it as a key in the temp table with their data. Then performing a select count..where sys_table_name = Temp_Table on sys_tables. If > 0 don't create table - just load. Then advancing a counter in a user_count temp table for each user that is using the table. Reduce the counter for each user that exits and dropping the table when the last user is done. I'm pretty confident this will work, but it doesn't seem very efficient. Does anyone have a better way? Thanks in avance for your help!
