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: Dynamic SQL and create sequence

Re: Dynamic SQL and create sequence

From: MarkyG <markg_at_mymail.tm>
Date: 8 Jan 2002 02:42:40 -0800
Message-ID: <ab87195e.0201080242.372b56bd@posting.google.com>


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

Original text of this message

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