Re: Using DDL commands in PL/SQL

From: <joseph_testa_at_aep.com>
Date: Wed, 29 Apr 1998 08:00:55 -0600
Message-ID: <6i78a7$a5u$1@nnrp1.dejanews.com>

That might be it, but more than likely, the user does NOT have the privileges granted explicitly and NOT thru the role. when executing stored procedures and dbms_sql, you cant have the privilege thru a role(ie:dba), create table, etc must be granted to the user explicitly.

joe
http://www.oracle-dba.com

In article <3545D72C.D5173F7E_at_compuserve.com>, Rod Corderey <Lane_Associates_at_compuserve.com> wrote:
>
> Mikael,
>
> has the user also got the necessary resource on the tablespace in which
> the table is being created?
>
> regards,
>
> Rod Corderey
> Lane Associates
> Lane_Associates_at_Compuserve.com
> http://www.Lane-Associates.com
>
> Mikael Schonenberg wrote:
> >
> > Through dbms_sql (in PL/SQL) I manage to use DDL commands, which is very
> > nice. Problem is I don't manage all of them. Drop Table works fine, but
> > when I try to Create Table it complaints about insufficient priviliges.
> > Well, I found that somewhat hard to believe, since the user woning
> > and running the PL/SQL package is granted the DBA role.
> >
> > Any idea?
> >
> > /Mikael
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Apr 29 1998 - 09:00:55 CDT