Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Why does Oracle ignore role-based privs in procedures?

Re: Why does Oracle ignore role-based privs in procedures?

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Wed, 03 Aug 2005 10:58:12 -0400
Message-ID: <42F0DB84.9060205@allegientsystems.com>


Jesse, Rich wrote:

>Why would role-based security be disabled in procedures? There must be
>a security issue here, but I'm not seeing it offhand.
>
>If roles were enabled in procs, it would certainly make my DBA tasks
>easier...
>
>

That is precisely why it isn't possible. Oracle doesn't want you to get too cozy and comfortable. You should
remember what Conan the Barbarian once said: what doesn't break you, makes you stronger. Conan the
Barbarian is now the governor of CA and Oracle simply acts accordingly. Hasta la vista, baby!

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 03 2005 - 09:59:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US