Re: DBAs, roles and privs

On Mon, 17 May 2004 22:03:48 +0200, Frank van Bortel <fvanbortel_at_netscape.net> wrote:

>> ok. too bad that global temporary tables are not perfectly
>> implemented.
>> yes, I know, the user should not have have the privs granted to them
>> or a role directly, use package.proc for the table create/drop where
>> GTTs are needed and grant exec on that.
>
>You don't create GTT's on the fly... Global (the G in GTT).
>On commit delete / preserve.
>When you log off: no more table.
>
>Is this system available on a variety of server back ends?
>I am beginning to suspect the programmer(s) / designer
>does not fully understand GTT's

 I think (or hope) he's just referring to the bugs with GTTs, such as the excessive redo generation associated with GTTs under certain circumstances - which was I believe fixed in 9.2.0.5 (or maybe even 9.2.0.4, I haven't the patch notes handy).

 GTTs are the right way to do it in theory, and hopefully now they're also the right way in practice as the big bugs are fixed.

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space