SYSPROCPERM system view

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.

Constraints on underlying system table

PRIMARY KEY (proc_id, grantee)

FOREIGN KEY (grantee) REFERENCES SYS.ISYSUSER (user_id)

FOREIGN KEY (proc_id) REFERENCES SYS.ISYSPROCEDURE (proc_id)

Discuss this page in DocCommentXchange.