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

SYSSYNCUSERS consolidated view Next Page

SYSTABAUTH consolidated view


The SYSTABAUTH view contains information from the SYSTABLEPERM system view, but in a more readable format.

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"."SYSTABAUTH"( grantor,
  grantee,screator,stname,tcreator,ttname,
  selectauth,insertauth,deleteauth,
  updateauth,updatecols,alterauth,referenceauth) 
  as select up1.user_name,up2.user_name,up3.user_name,tab1.table_name,
    up4.user_name,tab2.table_name,tp.selectauth,tp.insertauth,
    tp.deleteauth,tp.updateauth,tp.updatecols,tp.alterauth,
    tp.referenceauth from
    SYS.SYSTABLEPERM as tp join
    SYS.SYSUSERPERM as up1 on up1.user_id = tp.grantor join 
    SYS.SYSUSERPERM as up2 on up2.user_id = tp.grantee join
    SYS.SYSTABLE as tab1 on tab1.table_id = tp.stable_id join
    SYS.SYSUSERPERM as up3 on up3.user_id = tab1.creator join
    SYS.SYSTABLE as tab2 on tab2.table_id = tp.ttable_id join
    SYS.SYSUSERPERM as up4 on up4.user_id = tab2.creator
See also