Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with PL/SQL EXECUTE IMMEDIATE

Re: Problem with PL/SQL EXECUTE IMMEDIATE

From: Valery Yourinsky <vsu_at_bill.mts.ru>
Date: Tue, 20 Nov 2001 11:50:22 +0300
Message-ID: <3BFA194E.B04F2042@bill.mts.ru>


Katarina Amender wrote:
>
> Hi ewveryone!
>
> My two trainee students are trying to execute the following in an
> PL/SQL package in SQL Navigator against an Oracle 8.1.5 database
> running on WinNT sp4
>
> BEGIN
> EXECUTE IMMEDIATE 'CREATE TABLE X(A DATE)';
> END;
>
> We constantly get an error message saying that we don't have
> sufficient privileges.
>
> One strange thing is that I, as logged in as sysdba, can't give them
> rights to execute the package.
>
> Whats wrong??

   Grant CREATE TABLE privilege to user directly.    Not via role (DBA is your role)

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia
Received on Tue Nov 20 2001 - 02:50:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US