Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Why the DBMS_SQL can't parse the command(trigger)?
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