Mark, Thanks for the reply.

What SQL Server allows us to do is create a temporary table that
is available for the duration of the datasession. Once we
disconnect, the table is automatically dropped. The user does
not need create authority.

SQL Server example is...

create table #mytemptable(...)

We are looking to do something similar in Oracle 7.3.3.

Any suggestions are greatly appreciated.

Once again thanks, Vince