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