Re: DROP TABLE in STORED PROCEDURES

Hello,

                I think these are clearly mentioned in Oracle manuals.

1. you cannot directly execute any DDL from your stored procedure. Even if you are any super DBA this wont be allowed unless you use dynamic sql package dbms_sql or EXECUTE_DDL command. Try out these.
2. If you are granted DBA by role, still you wont be able to do this, because you need explicit permissions on the table and not any privileges granted by ROLE. I guess, this is also very clearly mentioned in Oracle administrators guide.

Hope this helps
Sanjay

"Diego Peroni" <peroni_at_cefriel.it> wrote:
>I inserted some 'DROP' statements in Oracle8 stored procedures... but when I>compiled it Oracle returns compilation errors for every DROP statement
>inserted!
>
>I'm SYSDBA and I have the permissions to create or destroy TABLES...
>
>Someone can help me?
>
>Thanks
>Diego Peroni
>
>
Received on Sun May 09 1999 - 23:15:21 CDT