Each row in the SYSPROCAUTH view describes a set of privileges granted on a procedure. As an alternative, you can also use the SYSPROCPERM system view.
The tables and columns that make up this view are provided in the SQL statement below. To learn more about a particular table or column, use the links provided beneath the view definition.
ALTER VIEW "SYS"."SYSPROCAUTH"( grantee, creator,procname ) as select u1.user_name,u2.user_name,p.proc_name from SYS.ISYSPROCEDURE as p join SYS.ISYSPROCPERM as pp on(p.proc_id = pp.proc_id) join SYS.ISYSUSER as u1 on u1.user_id = pp.grantee join SYS.ISYSUSER as u2 on u2.user_id = p.creator
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|