|
Each row in the SYSPROCAUTH view describes a set of privileges granted on a procedure. As an alternative, you can also use the SYSPROCPERM system view.
The tables and columns that make up this view are provided in the SQL statement below. To learn more about a particular table or column, use the links provided beneath the view definition.
ALTER VIEW "SYS"."SYSPROCAUTH"( grantee,
creator,procname)
as select up1.user_name,up2.user_name,p.proc_name from
SYS.SYSPROCEDURE as p key join
SYS.SYSPROCPERM as pp join
SYS.SYSUSERPERM as up1 on up1.user_id = pp.grantee join
SYS.SYSUSERPERM as up2 on up2.user_id = p.creator