Originally posted by Thomasps

Is it all_objects or user_objects..? I think all_objects is not appropriate here.
Given script can be executed by any user having necessary priviledges. You can also make use of USER_OBJECTS view, but in that case, you must connect to the user whos objects needs to be dropped and then execute the statement.

Sameer