(RADIATOR) multiple AuthBy SQL clauses and temporary tables

[Brown, Randy]

I am using AuthBy SQL with mysql 3.23. (Yes, it's old, but I don't have the option to change now.) I need several AuthBy SQL clauses to check for different authentication types, all querying the same database. In order to simplify the specific AuthBy queries, I'd like to create a temporary table in the first AuthBy SQL clause, and refer to it in subsequent AuthBy SQL clauses. So, I have a question about the lifetime of the connections, as the temporary table will disappear when the connection is closed. 

When are database connections closed? Is it safe to refer to a temporary table created in an early AuthBy SQL clause invoked for the same request? Do I need to define an AuthSQLStatement "create temporary table if not exist..." in each subsequent clause?

---
Randy Brown
Principal Security Engineer
Cable & Wireless
www.cw.com

email     randy.brown at cw.com
telephone +1-510-749-7035 
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.