|
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)