Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problem with dynamic DDL using Dbms_SQL
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. Your explanation is correct, but the problem is CREATE TABLE privilege through a role. Speaking from experience ........
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Sat Dec 07 2002 - 01:18:20 CST