Re: DBMS_PIPES

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/09/15
Message-ID: <341e735a.14222721@newshost>#1/1

You cannot create stored objects ( procedures, packages, views, etc) that access objects you have access to via a ROLE. Roles are always disabled during procedure/view execution.

To test if you have the need priveleges to access an object in a stored procedure or view, you can (and should) do the following in SQL*Plus:

SQL> set role none;
SQL> describe OBJECT_YOU_WANT_TO_ACCESS
SQL> set role all;

If the describe succeeds, you have the correct priveleges. If the describe fails, you will not be able to create a stored object that accesses that object. You will need to GRANT execute/select/whatever on OBJECT to THAT_USER. You need direct access, not via a role.

On Sun, 14 Sep 1997 06:05:00 GMT, hang_at_programmer.net (Jcen) wrote:

>Hi,
>
> I am also having this problem.
> Anybody has any solution?
> It's from the example in the Manuals.
> Thanks.
>
>
>
>On Fri, 29 Aug 1997 15:42:31 -0400, "Claude A. Charles"
><claude_charles_at_mail.amsinc.com> wrote:
>>I am working with DBMS_PIPES and I am running through a number of
>>problems. If I try to call the procedures in the DBMS_PIPE package in my
>>procedures I get this error message: PLS-00201: identifier
>>SYS.DBMS_PIPE' must be declared. But if I run the
>>SQL*Plus utility and I type the following code sample below on the
>>command line the execution is successful.
>>
>>BEGIN
>> DBMS_PIPE.PACK_MESSAGE('X')
>>END;
>>/
>>

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Sep 15 1997 - 00:00:00 CDT