我如何查看所有者是否有权在Oracle中执行存储过程 [英] How can i see if an owner has permissions to execute a Store Procedure in Oracle

问题描述

我需要验证我的所有者是否有权执行存储过程，但是我必须在sys表上进行搜索.我可以在哪个表中找到它.

I need to validate if my owner has permissions to execute a store procedure, but i have to do it searching on a sys table. In which table i can find it.

谢谢！

推荐答案

与它的名称相反，DBA_TAB_PRIVS允许我们查看所有对象的授权特权，而不仅仅是表.

Contrary to its name, DBA_TAB_PRIVS allows us to see granted privileges on all objects, not just table.

select * from DBA_TAB_PRIVS 
where type='PROCEDURE' 
and privilege='EXECUTE'
and OWNER='SCHEMANAME'
AND TABLE_NAME='PROCEDURENAME';

这篇关于我如何查看所有者是否有权在Oracle中执行存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！