Re: DBAs, roles and privs

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 17 May 2004 22:30:11 +0200
Message-ID: <c8b75e$1r2$1@news4.tilbu1.nb.home.nl>

Andy Hassall wrote:

> 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

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 ;) )

-- 

Regards,
Frank van Bortel

Received on Mon May 17 2004 - 15:30:11 CDT