Ian,
Sorry I dropped your note but you were experiencing a problem of not having
the privileges to perform certain statements using DBMS_SQL but you could
issue the statements in SQL*Plus. Here's probably what's happening. As roles
are disabled inside stored procedures, if you try to ALTER USER or CREATE TABLE
using the DBMS_SQL package and these privileges were granted to you via a role
then you will get an ORA_01031: INSUFFICIENT PRIVILEGES. If you grant the
privileges directly to the you (or some other user) then everything should
work fine.
HTH
Sean Snyder
Received on Mon Jan 08 1996 - 09:40:38 CST
