oracle查询以查找存储过程中的特权 [英] oracle query to find priveleges on a stored procedure

问题描述

我可以运行什么查询来简单地查看用户是否具有执行存储过程的特权.

What query can I run to simply see whether a user has privelege to execute a stored procedure.

让用户为UserA，存储过程名称为my_stored_proc

lets say user is UserA and stored procedure name is my_stored_proc

我想知道UserA是否具有对my_stored_proc

UserA不是storedproc的所有者.其他一些所有者授予他许可.

UserA is not the owner of the storedproc. Some other owner grants him the permission.

推荐答案

要通过角色说明拨款:

  select grantee, table_name, privilege
     from dba_tab_privs
     where
       table_name = 'my_stored_proc'
        and 
       owner = 'ownerOfObject'
       and
       (grantee = 'userA'
         or
         grantee in
          (select granted_role
        from dba_role_privs
        where grantee = 'userA'
           )
        )

这篇关于oracle查询以查找存储过程中的特权的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！