Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> top 10 oracle quirks
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.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.comReceived on Wed Aug 06 2003 - 11:01:21 CDT
-------------------------------------
![]() |
![]() |