Re: Problem with PL/SQL EXECUTE IMMEDIATE

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