Re: Create database link from inside a stored procedure

In article <1143561695.553616.195900_at_j33g2000cwa.googlegroups.com>, Mark D Powell says...
> jeremy, generally speaking for user A to place any SQL that he or she
> can run successfully in SQLPlus into stored code and have it work, user
> A must have a direct grant of the necessary privilege to him or her
> rather than having inherited that privilege through a role.
>
> HTH -- Mark D Powell --
>
>

Thanks - I actually thought I had the grant explicitly rather than via a role - lost points for not checking before posting.

-- 

jeremy