SYSCA views are views defined on a subset of SYSTEM tables. They restrict information that the user can select from the SYSTEM tables to data about tables for which the user holds SELECT privilege.
If you hold SELECT privilege on the SYSCA views but not on SYSTEM tables, you can see definitions of the tables from which you are authorized to select data, but you cannot see definitions of any other tables defined in the catalog component of the dictionary.
SYSCA.ACCESSIBLE_TABLES is a view you can use to list the tables for which you hold a SELECT privilege. The result table of this view contains the schema name, table name, and type of table (T for base table, V for view, N for non-SQL-defined table, P for table procedure), as in this example:
SELECT * FROM SYSCA.ACCESSIBLE_TABLES;
*+
*+ SCHEMA TABLE TYPE
*+ ────── ───── ────
*+ DEMOEMPL EMP_WORK_INFO V
*+ DEMOEMPL JOB T
*+ DEMOPROJ EXPERTISE T
*+ DEMOPROJ PROJECT T
*+ DEMOPROJ SKILL T
*+ EMPDEMO INSURANCE-PLAN N
*+ SYSCA ACCESSIBLE_TABLES V
*+ SYSCA COLUMN V
*+ SYSCA SECTION V
*+ SYSCA SYNTAX V
*+ SYSCA TABLE V
Non-SQL defined tables are visible through the SYSCA.ACCESSIBLE_TABLES view only if the dictionary name where the non-SQL-defined schema resides exactly matches the dictionary to which the SQL session is connected.
In addition to SYSCA.ACCESSIBLE_TABLES, these SYSCA views are defined. The view name matches the name of the SYSTEM table on which it is defined, and the view column names match the SYSTEM table column names.
|
Copyright © 2014 CA.
All rights reserved.
|
|