Re: Why does PURGE DBA_RECYCLEBIN require SYSDBA?

Why indeed. It appears you were on to something. This requirement has changed in 12c.

*This clause is valid only if you have
the SYSDBA or PURGE DBA_RECYCLEBIN system privilege. It lets you remove all objects from the system-wide recycle bin, and is equivalent to purging the recycle bin of every user. This operation is useful, for example, before backward migration.*

Seth Miller

On Mon, Jul 28, 2014 at 11:35 AM, Rich Jesse < rjoralist3_at_society.servebeer.com> wrote:

> Hey all,
>
> Dealing with data refreshes and some recyclebin issues in 11.2.0.3, and the
> topic of DBA_RECYCLEBIN rears it's ugly head again. Why exactly is the
> special SYSDBA priv required to PURGE DBA_RECYCLEBIN when a workaround of
> iteratively purging the collective tablespace/user combinations in
> DBA_RECYCLEBIN requires only DROP ANY?
>
> I had started a blog years ago to show how this and other "security"
> aspects
> in Oracle are pointless as there are easy workarounds, but never took the
> time. And I *must* be missing some valid reason, right?
>
> TIA,
> Rich
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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