Re: Why can't use the package DBMS_SQL ?

Dick Wong wrote:

> 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

  You should also have a "CREATE USER" priviledge.

--
Vitaly Sikolenko                  Senior Sales Consultant
                                  Server & Gateways
ORACLE C.I.S.
Moscow Russia                      E-mail: vsikolen_at_ru.oracle.com

The statements and opinions expressed here are my own and do not
necessarily represent those of Oracle Corporation.