Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Other schema objects in stored functions
Uwe Schneider wrote:
>
> Hi experts,
>
> while trying to create a stored function (CREATE FUNCTION) in Oracle
> server
> (7.3.3) I experienced a strange problem:
>
> Although I can read an other user's tables (select, describe)
> I can't reference them in SELECT statements within a stored function.
>
> Is this true? Or am I lacking any privileges?
When you create a stored object, the schema that owns the stored object
must have *direct* privileges on every referenced object that is not
owned by that schema -- the privileges cannot come through roles. If
you can currently SELECT the objects in question because of privs.
acquired thru a role you must replace them with explicit GRANTs to
create the stored object.
--
Vincent Ventrone | The MITRE Corp. DBA, Dept. R101 | M/S C020 vav_at_mitre.org | 202 Burlington Rd. (781) 271-7048 | Bedford, MA 01730Received on Fri Jul 02 1999 - 13:13:48 CDT