Re: declare SYS.DBMS_PIPE???

From: Greg G <ggershSNACK_at_CAKEctc.net>
Date: Thu, 06 Nov 2003 12:04:54 -0500
Message-ID: <j9ednUQXGOnI4jeiRVn-jw@ctc.net>

See the "grant execute hanging!?" thread. The grant is just flat timing out. The DBA_TAB_PRIVS has some entries, but the grant never seems to insert the new data into it.

-Greg G

mcstock wrote:

> i hadn't seen that post ...
>
> what ORA- error are you getting?
>
> also, check DBA_TAB_PRIVS to make sure if the missing grant is the problem
> or not
>
> "Greg G" <ggershSNACK_at_CAKEctc.net> wrote in message
> news:cbOdnQCqfsya-jeiRVn-jA_at_ctc.net...
>

>>
>>mcstock wrote:
>>
>>
>>>that probably means that the schema you're using does not have execute
>>>permission on DBMS_PIPE (there apparently is a public synonym mapping
>>>DBMS_PIPE to SYS.DBMS_PIPE, since the error message figured out the

>
> package
>

>>>owner)
>>>
>>>if you're creating a stored procedure, the schema must have EXECUTE
>>>permission directly granted to it (not via a role) or EXECUTE permission
>>>must be granted to PUBLIC (which not every dba would want to do with
>>>DBMS_PIPE)
>>
>>    That's what I thought was happening.  However, as I posted in
>>another  message, the GRANT command is hanging up and timing out.
>>
>>-Greg G
>>

>
>
>
Received on Thu Nov 06 2003 - 11:04:54 CST