FAQ
Jason, I think you're on to something here. According to the docs, only the
DBA_RECYCLEBIN option of PURGE requires SYSDBA, so if I build a list of
objects in there first and purge them one at a time, I only need SELECT on
the DBA_RECYCLEBIN view and DROP ANY for objects outside the definer's
schema.

It's annoying to have to code workarounds to Oracle "security".
It's like being back in 8i all over again.

Thanks, Jason!!!
Rich
I created a procedure once that queried dba_recyclebin and purged all of the
table objects older than a specified age. I don't recall having the
problems you described, probably because the script purged the individual
objects rather than the whole recyclebin. You may want to consider that
approach as a workaround to your problem.
--
http://www.freelists.org/webpage/oracle-l

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 4 of 4 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedDec 6, '07 at 9:09p
activeDec 7, '07 at 6:50p
posts4
users2
websiteoracle.com

2 users in discussion

Rich Jesse: 3 posts Yasin Baskan: 1 post

People

Translate

site design / logo © 2022 Grokbase