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: Jared Still <jkstill_at_gmail.com>
Date: Wed, 3 Aug 2005 09:50:50 -0700
Message-ID: <bf463805080309505d7b8bdb@mail.gmail.com> 





On 8/3/05, Goulet, Dick <DGoulet_at_vicr.com> wrote:


> 

> That changed in 10G I do believe.






No, it is the same.



http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14220/security.htm#i14426



Roles were intended as a method to simplify the administration of user 
privileges,


and do not apply to the creation of stored procedures and views.



The following MetaLink notes give some explanation:
11740.1


1011899.6


13615.1



-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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


Received on Wed Aug 03 2005 - 11:52:59 CDT












Original text of this message













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