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)
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|