Re: create synonym with dbms_sql (Oracle8.0.5)

miguelangel6886_at_my-deja.com wrote:
>
> Hi!
> I am unable to create a synonym embedded
> in a pl/sql function. When I use dbms_sql I get the
> error message: 1031: Insufficient privileges.
> The code is as follows:
>
> dbms_sql.parse(cur,'CREATE SYNONYM "MYSYNONYM" FOR
> MGR.R_CALLEDEV',dbms_sql.native);
>
> user MGR has privileges to create the synonym.
> Owner of dbms_sql is SYS and also has privileges to create a synonym.
>
> Any help please?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Note that with a procedure the 'create synonym' privilege must be granted directly not via a role....

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse