| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Help needed on DBMS_SQL
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 CDT
 |
 |