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

SYSCATALOG consolidated view Next Page

SYSCOLAUTH consolidated view

Each row in the SYSCOLAUTH view describes the set of privileges (UPDATE , SELECT, or REFERENCES) granted on a column. The SYSCOLAUTH view provides a user-friendly presentation of data in the SYSCOLPERM 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"."SYSCOLAUTH"( grantor,grantee,creator,tname,colname,
  as select up1.user_name,up2.user_name,up3.user_name,tab.table_name,
    col.column_name,cp.privilege_type,cp.is_grantable from
    SYS.SYSCOLPERM as cp join
    SYS.SYSUSERPERM as up1 on up1.user_id = cp.grantor join
    SYS.SYSUSERPERM as up2 on up2.user_id = cp.grantee join
    SYS.SYSTABLE as tab on tab.table_id = cp.table_id join
    SYS.SYSUSERPERM as up3 on up3.user_id = tab.creator join
    SYS.SYSCOLUMN as col on col.table_id = cp.table_id and
    col.column_id = cp.column_id
See also