ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraints |
|---|---|---|---|
| proc_id | UNSIGNED INT | NOT NULL | Primary key. Foreign key references SYSPROCEDURE |
| grantee | UNSIGNED INT | NOT NULL | Primary key. Foreign key references 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.