Re: grant execute hanging!?

Chris Leonard wrote:
> Greg,
>
> I can't help you with why the grant is hanging without more information,

    What information can I give you to help diagnose this? I'm working with Oracle 8.1.7.0.0 (yeah, I know, I know) if that helps any.

 > but
> one way to see what users have already been granted the execute privilege on
> DBMS_PIPE is to run this query:
>
> select * from dba_tab_privs
> where owner = 'SYS' and table_name = 'DBMS_PIPE'

    That returns me 6 reasonable-looking rows.

> Since DBMS_PIPE is a package, only the EXECUTE privilege applies to it, and
> these are all listed in DBMS_TAB_PRIVS. Of course, several GUI tools, such
> as the Oracle Enterprise Manager, will run the query for you and show you
> these permissions as well.

    Where in the OEM can I find that? I didn't see anything in the pre-defined charts for that.

    Thanks.

-Greg G Received on Mon Nov 03 2003 - 12:32:36 CST