Re: declare SYS.DBMS_PIPE???

Greg G wrote:

>
> Oh, I forgot to mention one other thing that makes this really weird.
> My userid has DBA privs...
>
> -Greg G
>
>
> Greg G wrote:
>
>> 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
>>>>

Whoever is managing this little shop of horrors should go back to basics. Bounce the
server. Does the GRANT still hang? If so I'd be running export to verify logical integrity,
catalog.sql, catproc.sql, etc. Bounce the sever again. Does the GRANT still hang? If so
I'd be opening an iTAR.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)