Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Why the DBMS_SQL can't parse the command(trigger)?

Re: Why the DBMS_SQL can't parse the command(trigger)?

From: Adrian <adrian.billington_at_virgin.net>
Date: Wed, 15 Dec 1999 21:13:41 -0000
Message-ID: <838vu3$4bu$1@nclient13-gui.server.virgin.net>


You need privileges granted to execute the DBMS_SQL package, as it is owned by SYS. I believe this is something like the "execute any package" privilege, which although encapsulated by DBA role, needs to be explicitly stated. Check the syntax but something like grant execute any package to username. Received on Wed Dec 15 1999 - 15:13:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US