Help needed on DBMS

From: Maarten Scharroo <m.scharroo_at_elsevier.nl>
Date: 1998/08/12
Message-ID: <01bdc5ff$671677e0$7d0c2491@C30487.elsevier.nl>#1/1

Hi,

I try to use dbms_sql to create a synonym.

Code:

DECLARE    C1 INTEGER;
   Dummy INTEGER;
   CommandStr VARCHAR2(240);

BEGIN
C1 := dbms_sql.open_cursor;
CommandStr := 'create synonym elap_actions_current for elap_actions_sep';

   dbms_sql.parse( C1, CommandStr, dbms_sql.v7 );
   dbms_sql.execute( C1 );
   dbms_sql.close_cursor(C1);

END;
/

This works....

Put the same code in a packaged function yields....

ORA-01031: insufficient privileges

The user has the CREATE SYNONYM privilege granted.........

Thanks in advance

Maarten Received on Wed Aug 12 1998 - 00:00:00 CDT

Help needed on DBMS_SQL