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
>>>
>>
>>
>>
>
Received on Thu Nov 06 2003 - 12:43:54 CST