Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Dynamic SQL and create sequence
Thats the answer.
Well done ;-)
M
"Yann CAUCHARD" <yann.cauchard_at_spcconsultants.com> wrote in message news:<a1c6pm$e7a$1_at_news5.isdnet.net>...
> I found the answer :
>
> the PL/SQL is ran with 'no' user, it means no privilege to create objects.
>
> The only way i found (i use) is to grant create sequence directly to the
> user (not through a role), and It works fine.
>
> Yann
>
Received on Tue Jan 08 2002 - 04:42:40 CST