Reference Manual
CHAPTER 16. System Views
CREATE VIEW SYS.SYSPROCAUTH(grantee,
creator,procname)
AS
SELECT(select user_name FROM SYS.SYSUSERPERM
WHERE SYSPROCPERM.grantee=SYSUSERPERM.user_id),
(select user_name FROM SYS.SYSUSERPERM
WHERE SYSPROCEDURE.creator=SYSUSERPERM.user_id),
proc_name
FROM
SYS.SYSPROCEDURE JOIN SYS.SYSPROCPERM
Presents the procedure authorities from SYSUSERPERM in a more readable format.