Each row of the SYSPROCPERM system view describes a user who has been granted EXECUTE privilege on a procedure. The underlying system table for this view is ISYSPROCPERM.
Column name | Data type | Description |
---|---|---|
proc_id | UNSIGNED INT | The procedure number uniquely identifies the procedure for which EXECUTE privilege has been granted. |
grantee | UNSIGNED INT | The user number of the privilege grantee. |
PRIMARY KEY (proc_id, grantee)
FOREIGN KEY (grantee) REFERENCES SYS.ISYSUSER (user_id)
FOREIGN KEY (proc_id) REFERENCES SYS.ISYSPROCEDURE (proc_id)