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 | Description |
|---|---|---|
| proc_id | UNSIGNED INT | The procedure number uniquely identifies the procedure for which permission has been granted. |
| grantee | UNSIGNED INT | 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)
| Envoyer votre avis sur cette page par email. | Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |