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

上一篇 / 下一篇 2008-01-24 15:04:38 / 个人分类：pl/sql

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>

导入论坛引用链接收藏分享给好友推荐到圈子管理举报

TAG:

查看全部评论