Im trying to create a procedure which references a synonym.
The synonym is based on a table from a different schema .
I get this error when i try to create the procedure . .
PL/SQL: ORA-01031: insufficient privileges
create or replace procedure MyProc
tot number ;
from synonym my_Syn_Name ;
If I run the 'select' statement from PLUS I have no errors.
The owner of the synonym is the same as the schema in which I am creating
The owner of the table on which the synonym is based is in another schema.
The user (that is creating the procedure) has full DBA privileges .
Can anyone Help ? Th eversion of Oracle is 9.2