DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-01031: insufficient privileges - procedure with synonym

Hybrid View

  1. #1
    Join Date
    Apr 2007
    Posts
    2

    Question ORA-01031: insufficient privileges - procedure with synonym

    Hi,

    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
    Eg .

    create or replace procedure MyProc
    is
    tot number ;
    Begin
    select count(*)
    into tot
    from synonym my_Syn_Name ;
    END ;

    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 Procedure.

    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

    Thanks

  2. #2
    Join Date
    Apr 2007
    Posts
    2
    Its ok, granted select to underlying table .. .
    problem solved

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You need a direct select grant on the underlying table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width