SYSPROCPERM system table

Reference Manual
CHAPTER 15. System Tables

SYSPROCPERM system table

Column name

Column type

Column constraint

Table constraints

proc_id

SMALLINT

NOT NULL

Primary key

grantee

SMALLINT

NOT NULL

Primary key, foreign key references SYS.SYSUSERPERM. user_id

Column name	Column type	Column constraint	Table constraints
proc_id	SMALLINT	NOT NULL	Primary key
grantee	SMALLINT	NOT NULL	Primary key, foreign key references SYS.SYSUSERPERM. user_id

Only users who have been granted permission can call a procedure. Each row of the SYSPROCPERM table corresponds to one user granted permission to call one procedure.

proc_id The procedure number uniquely identifies the procedure for which permission has been granted.

grantee The user number of the user ID receiving the permission.