Re: PUBLIC privileges on XDB$ACL
Date: Thu, 19 Jul 2012 15:23:00 +0100
Indeed. That line is there in 10.2 as well. In 11.2 there's a comment about removing the privilege
*Rem sidicula 01/13/07 - Restrict privileges on ACL tab*
I imagine that this fix is in 11.2 and possibly patchsets to prior releases where the patchset was released after January 2007.
On Thu, Jul 19, 2012 at 2:48 PM, Rich Jesse < rjoralist2_at_society.servebeer.com> wrote:
> David writes:
> > I'm trying to track down the source of a overly permissive privilege
> > on XDB$ACL. At about Oracle 9.2 when Oracle XML Database is installed it
> > seems catqm.sql (or one of its sub-scripts) executed
> > "grant all on XDB.XDB$ACL to public"
> In 10.1.0.5 (AIX), it's in ?/rdbms/admin/catxdbz.sql, apparently from
> 02/19/02 and with a comment of "Make XDB$ACL writeable by all users"
> immediately preceding it.
> The "commit" following the GRANT is curious....
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 19 2012 - 09:23:00 CDT