Re: problem with dynamic DDL using Dbms_SQL

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:v383vuspj5g4jovtfaa18hjq6i19qefqln_at_4ax.com...
> On Sat, 7 Dec 2002 18:08:54 +1100, "Howard J. Rogers"
> <howardjr2000_at_yahoo.com.au> wrote:
>
> >Almost certainly, the problem is that you do not have rights to the
> >SYS.DBMS_SQL package. Hence the 'insufficient privileges' error message.
>
>
> Sorry to contradict you.

No worries. Often I deserve it.

>Your explanation is correct, but the problem
> is CREATE TABLE privilege through a role.

Yup. Can't think what I was thinking of. Had the problem been with the package, the error would have been something like 'identifier DBMS_SQL must be declared'. Create table privilege it is.

Regards
HJR
> Speaking from experience ........
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sat Dec 07 2002 - 12:50:38 CST