Each row of the SYSPROCPERM system view describes a user granted permission to execute a procedure. Only users who have been granted permission can execute a procedure. The underlying system table for this view is ISYSPROCPERM.
|Column name||Column type||Column constraint|
|proc_id||UNSIGNED INT||NOT NULL|
|grantee||UNSIGNED INT||NOT NULL|
proc_id The procedure number uniquely identifies the procedure for which permission has been granted.
grantee The user number of the user receiving the permission.
PRIMARY KEY (proc_id, grantee)
FOREIGN KEY (grantee) references SYS.ISYSUSER (user_id)
FOREIGN KEY (proc_id) references SYS.ISYSPROCEDURE (proc_id)