Re: top 10 oracle quirks

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Thu, 7 Aug 2003 16:20:32 +0200
Message-ID: <1060265966.369888@news.thyssen.com>

Hi Norm,

I suppose '9i' was a simple typo, right? I'm sure you meant 8(i?)?

Greetings,
Guido

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> schrieb im Newsbeitrag news:E2F6A70FE45242488C865C3BC1245DA703FF9662_at_lnewton.leeds.lfs.co.uk. ..
> I 'like' the way I can create a synonym for a tablespace :o)
> (But never use it as such !)
>
> I 'like' the way that roles are turned off for PL/SQL procs and
> functions, but not for anonymous blocks, and now, since 9i, if the
> proc/function (or package) is defined with DEFINER rights, the roles
are
> turned off, but if defined with INVOKER rights, they are left turned
on.
>
> Cheers,
> Norm.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
Received on Thu Aug 07 2003 - 09:20:32 CDT