Re: Help needed on DBMS_SQL
From: Mark <lambicm_at_yahoo.com>
Date: 1998/08/12
Message-ID: <35D1B12D.5384_at_yahoo.com>#1/1
Date: 1998/08/12
Message-ID: <35D1B12D.5384_at_yahoo.com>#1/1
Maarten Scharroo wrote:
> This works....
>
> Put the same code in a packaged function yields....
>
> ORA-01031: insufficient privileges
>
> The user has the CREATE SYNONYM privilege granted.........
My guess is you have CREATE SYNONYM granted through a role. Stored packages and procedures don't recognise role grants. Received on Wed Aug 12 1998 - 00:00:00 CEST