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

  • From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
  • To: Rich.Jesse@xxxxxxxxxxxxxxxxx
  • Date: Wed, 03 Aug 2005 10:58:12 -0400

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


-- //www.freelists.org/webpage/oracle-l

Other related posts: