Re: DBMS_SQL and insufficient user privilege

That worked great! Thanks for you help Mark.

pat

markg_at_mymail.co.uk (Mark) wrote in message news:<ddb31653.0203200106.40d378f7_at_posting.google.com>...
> Age old problem.
>
> Make sure the user has the CREATE SEQUENCE priv granted to them
> directly as opposed to having it via a role.
>
> Mark
>
> phoran22_at_yahoo.com (Pat) wrote in message news:<1a8641b.0203191001.2df4d91e_at_posting.google.com>...
> > I'm currently having an issue where I'm trying to create a in a pl/sql
> > script using the DBMS_SQL package. However, I keep getting an error
> > on insufficient user privilege. The user running the script has
> > privilege to create the sequence and I haven't had any trouble when
> > creating other objects like indexes. Has anybody else ever had this
> > problem? Any help at all would be greatly appreciated.
> >
> > Thanks!
> >
> > pat
Received on Wed Mar 20 2002 - 21:08:55 CET