SQL>

SQL> grant execute on  aw_drop_proc to paul;

Grant succeeded

SQL> select * from dba_tab_privs where table_name='AW_DROP_PROC'

  2  ;

GRANTEE                        OWNER                          TABLE_NAME                     GRANTOR                        PRIVILEGE                                GRANTABLE HIERARCHY

------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------------------- --------- ---------

PAUL                           SYS                            AW_DROP_PROC                   SYS                            EXECUTE                                  NO        NO

SQL>

如何查哪些用户拥有execute 某个procedure的权限？