如何创建一个查询来显示我可以访问的所有函数和过程?SQL Oracle



SELECT * 
FROM all_source
WHERE type in ('PROCEDURE', 'FUNCTION')
AND OWNER = ''; -- ENTER YOUR OWNER NAME HERE

或者这就是你想要的：

SELECT *
FROM dba_tab_privs
WHERE TYPE IN ('PROCEDURE', 'FUNCTION')
AND (GRANTEE = '' -- ENTER YOUR USER NAME HERE
OR GRANTEE in (SELECT granted_role
FROM dba_role_privs
WHERE GRANTEE = '') -- ENTER YOUR USER NAME HERE