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

Home -> Community -> Usenet -> c.d.o.server -> Why can't use the package DBMS_SQL ?

Why can't use the package DBMS_SQL ?

From: Dick Wong <dickwong_at_hk.super.net>
Date: 1997/08/10
Message-ID: <33EDB235.55758C9C@hk.super.net>#1/1 







I want to write a generic store procedure to create Oracle Database User
Account with the use of dynamic SQL.  I have used the Oracle built-in
package DBMS_SQL and have no error during compliation.  But, when I
execute my store procedure, I get the error message :
INSUFFIENT PRIVILEGE


I sure that the SYS account have granted exeute on DBMS_SQL to public
and created a public synonym for that package.  Why can't me use this in
another user account ?



Any solution or hints are welcome, Thank you.



Dick Wong
Received on Sun Aug 10 1997 - 00:00:00 CDT












Original text of this message













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