Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » Consolidated views

SYSOPTIONS consolidated view Next Page

SYSPROCAUTH consolidated view


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 up1.user_name,up2.user_name,p.proc_name from
    SYS.SYSPROCEDURE as p key join
    SYS.SYSPROCPERM as pp join
    SYS.SYSUSERPERM as up1 on up1.user_id = pp.grantee join
    SYS.SYSUSERPERM as up2 on up2.user_id = p.creator
See also