top 10 oracle quirks

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 6 Aug 2003 17:01:21 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703FF9662@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 Wed Aug 06 2003 - 11:01:21 CDT