Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insufficient privileges from procedure

salmanqureshi-2314430Feb 7 2013 — edited Feb 7 2013

Hi,
In 11.1.0.7 on SOLARIS, I have a procedure created in SYSTEM schema which queries dba_tables and then uses dynamic sql to drop some tables from a schema (lets assume schema name ABC).
When I execute this procedure, i receive ORA-01031: Insufficient Privileges error.
If I execute same code as a PL/SQL box (not procedure), I am able to run this code and drop all the tables which meet criteria.

Any idea why oracle does not allow a procedure in SYSTEM schema to drop these tables from another schema? and letting me drop from PL/SQL block.

Salman

This post has been answered by RNi on Feb 7 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2013

Added on Feb 7 2013

#general-database-discussions

10 comments

2,644 views