Re: Using DDL commands in PL/SQL

From: Steve Johnson <sjohnson3_at_aegonusa.com-nospam>
Date: 28 Apr 1998 17:39:34 GMT
Message-ID: <01bd72cc$d3984af0$2fc57ba2@ws0008083080>

When running dbms_sql the user must have explicit permissions on the object.
Not through a role. So make sure that the user has the necessary permissions
granted directly to him.

Steve J.

Mikael Schonenberg <micke_at_netg.se> wrote in article <Pine.LNX.3.96.980428141316.23404A-100000_at_valdez.netg.se>...
>
> 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
>
>
Received on Tue Apr 28 1998 - 12:39:34 CDT