Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01031 insufficient privileges

francy77Oct 25 2010 — edited Oct 25 2010
Hi all,
when i try do do the following statment in a stored procedure:

execute immediate 'create view pippo as select CODSTR from anagrafiche';


it give me the error ORA-01031 insufficient privileges

even if the user by wich i run the procedure as the privileges as a dba

GRANT DBA TO UTENTE_SDO WITH ADMIN OPTION;

why this happen?

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 22 2010
Added on Oct 25 2010
#9i
10 comments
200 views