Re: DBMS_SQL and insufficient user privilege

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 - 10:06:33 CET