Re: DBAs, roles and privs

On Mon, 17 May 2004 22:30:11 +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 - to do what: create and drop on the fly? Why would you
>do that? Can't imagine a reason for that (but it's late ;) )

• re-reads post
• sees point
• shuts mouth again

 ;-)

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