Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\browserasst\views\public_views

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\browserasst\views\public_views_wksp.sql

CREATE OR REPLACE VIEW ALL_IV_PROJECTS AS SELECT * FROM WB$_IV_PROJECTS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_INSTALLATIONS AS SELECT * FROM WB$_IV_INSTALLATIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_OBJECTS AS SELECT * FROM WB$_IV_OBJECTS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_FOLDERS AS SELECT * FROM WB$_IV_FOLDERS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_FLD_CONTAINED_OBJECTS AS SELECT * FROM WB$_IV_FLD_CONTAINED_OBJECTS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_FIRSTCLASS_OBJECTS AS SELECT * FROM WB$_IV_FIRSTCLASS_OBJECTS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_INFORMATION_SYSTEMS AS SELECT * FROM WB$_IV_INFORMATION_SYSTEMS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_MODULES AS SELECT * FROM WB$_IV_MODULES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_DIMENSIONS AS SELECT * FROM WB$_IV_DIMENSIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_DIM_ROLES AS SELECT * FROM WB$_IV_DIM_ROLES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_DIM_LEVELS AS SELECT * FROM WB$_IV_DIM_LEVELS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_DIM_LEVEL_ATTRIBUTES AS SELECT * FROM WB$_IV_DIM_LEVEL_ATTRIBUTES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_DIM_ATTRIBUTES AS SELECT * FROM WB$_IV_DIM_ATTRIBUTES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_DIM_HIERARCHIES AS SELECT * FROM WB$_IV_DIM_HIERARCHIES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_DIM_HIERARCHY_LEVELS AS SELECT * FROM WB$_IV_DIM_HIERARCHY_LEVELS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CUBES AS SELECT * FROM WB$_IV_CUBES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CUBE_MEASURES AS SELECT * FROM WB$_IV_CUBE_MEASURES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CUBE_MEASURE_DIM_USES AS SELECT * FROM WB$_IV_CUBE_MEASURE_DIM_USES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CUBE_DIMENSIONS AS SELECT * FROM WB$_IV_CUBE_DIMENSIONS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CUBE_IMPLS AS SELECT * FROM WB$_IV_CUBE_IMPLS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_DIM_LEVEL_IMPLS AS SELECT * FROM WB$_IV_DIM_LEVEL_IMPLS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_DIM_IMPLS AS SELECT * FROM WB$_IV_DIM_IMPLS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_TABLES AS SELECT * FROM WB$_IV_TABLES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_RELATIONS AS SELECT * FROM WB$_IV_RELATIONS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_VIEWS AS SELECT * FROM WB$_IV_VIEWS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_MATERIALIZED_VIEWS AS SELECT * FROM WB$_IV_MATERIALIZED_VIEWS   where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_SEQUENCES AS SELECT * FROM WB$_IV_SEQUENCES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CHECK_CONSTRAINTS AS SELECT * FROM WB$_IV_CHECK_CONSTRAINTS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CONSTRAINTS AS SELECT * FROM WB$_IV_CONSTRAINTS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_KEYS AS SELECT * FROM WB$_IV_KEYS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_FOREIGN_KEYS AS SELECT * FROM WB$_IV_FOREIGN_KEYS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_KEY_COLUMN_USES AS SELECT * FROM WB$_IV_KEY_COLUMN_USES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_COLUMNS AS SELECT * FROM WB$_IV_COLUMNS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_FILES AS SELECT * FROM WB$_IV_FILES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_RECORDS AS SELECT * FROM WB$_IV_RECORDS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_FIELDS AS SELECT * FROM WB$_IV_FIELDS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_ALL_OBJECTS AS SELECT * FROM WB$_IV_ALL_OBJECTS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_RECORD_FIELDS AS SELECT * FROM WB$_IV_RECORD_FIELDS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_FUNCTION_LIBRARIES AS SELECT * FROM WB$_IV_FUNCTION_LIBRARIES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_FUNCTIONS AS SELECT * FROM WB$_IV_FUNCTIONS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_PROCEDURES AS SELECT * FROM WB$_IV_PROCEDURES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_DB_FUNCTIONS AS SELECT * FROM WB$_IV_DB_FUNCTIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_TABLE_FUNC_PROPERTIES AS SELECT * FROM WB$_IV_TABLE_FUNC_PROPERTIES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_FUNCTION_PARAMETERS AS SELECT * FROM WB$_IV_FUNCTION_PARAMETERS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_FUNCTION_IMPLS AS SELECT * FROM WB$_IV_FUNCTION_IMPLS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
-- 	'CREATE OR REPLACE VIEW ALL_IV_MINING_MODELS AS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_XFORM_MAPS AS SELECT * FROM WB$_IV_XFORM_MAPS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_XFORM_MAP_COMPONENTS AS SELECT * FROM WB$_IV_XFORM_MAP_COMPONENTS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_XFORM_MAP_GROUPS AS SELECT * FROM WB$_IV_XFORM_MAP_GROUPS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_XFORM_MAP_PARAMETERS AS SELECT * FROM WB$_IV_XFORM_MAP_PARAMETERS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_XFORM_MAP_DETAILS AS SELECT * FROM WB$_IV_XFORM_MAP_DETAILS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_EXEC_UNITS AS SELECT * FROM WB$_IV_EXEC_UNITS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_EXEC_UNIT_MAP_COMP_USES AS SELECT * FROM WB$_IV_EXEC_UNIT_MAP_COMP_USES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_EXEC_UNIT_CT_USES AS SELECT * FROM WB$_IV_EXEC_UNIT_CT_USES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_OBJECT_PROPERTIES AS SELECT * FROM WB$_IV_OBJECT_PROPERTIES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_SUPPORTED_LANGUAGES AS SELECT * FROM WB$_IV_SUPPORTED_LANGUAGES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_MLS_OBJECTS AS SELECT * FROM WB$_IV_MLS_OBJECTS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_ATTR_GROUPS AS SELECT * FROM WB$_IV_ATTR_GROUPS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_ATTR_GROUP_ITEM_USES AS SELECT * FROM WB$_IV_ATTR_GROUP_ITEM_USES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_COLLECTIONS AS SELECT * FROM WB$_IV_COLLECTIONS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_COLLECTION_REFERENCES AS SELECT * FROM WB$_IV_COLLECTION_REFERENCES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_PROCESS_MODULES AS SELECT * FROM WB$_IV_PROCESS_MODULES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_PROCESSES AS SELECT * FROM WB$_IV_PROCESSES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_SUB_PROCESSES AS SELECT * FROM WB$_IV_SUB_PROCESSES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_PACKAGES AS SELECT * FROM WB$_IV_PACKAGES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_PROCESS_ACTIVITIES AS SELECT * FROM WB$_IV_PROCESS_ACTIVITIES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_PROCESS_VARIABLES AS SELECT * FROM WB$_IV_PROCESS_VARIABLES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_PROCESS_PARAMETERS AS SELECT * FROM WB$_IV_PROCESS_PARAMETERS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_PROCESS_TRANSITIONS AS SELECT * FROM WB$_IV_PROCESS_TRANSITIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_EXPERTS AS SELECT * FROM WB$_IV_EXPERTS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_EXPERT_MODULES AS SELECT * FROM WB$_IV_EXPERT_MODULES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_EXPERT_VARIABLES AS SELECT * FROM WB$_IV_EXPERT_VARIABLES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_EXPERT_PARAMETERS AS SELECT * FROM WB$_IV_EXPERT_PARAMETERS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_EXPERT_TRANSITIONS AS SELECT * FROM WB$_IV_EXPERT_TRANSITIONS   where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_NESTED_EXPERTS AS SELECT * FROM WB$_IV_NESTED_EXPERTS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_EXPERT_TASKS AS SELECT * FROM WB$_IV_EXPERT_TASKS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CTS AS SELECT * FROM WB$_IV_CTS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CT_FOLDERS AS SELECT * FROM WB$_IV_CT_FOLDERS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CT_VARIABLES AS SELECT * FROM WB$_IV_CT_VARIABLES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CT_PARAMETERS AS SELECT * FROM WB$_IV_CT_PARAMETERS   where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CT_TRANSITIONS AS SELECT * FROM WB$_IV_CT_TRANSITIONS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CT_TASKS AS SELECT * FROM WB$_IV_CT_TASKS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_SAP_MODULES AS SELECT * FROM WB$_IV_SAP_MODULES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_FILE_MODULES AS SELECT * FROM WB$_IV_FILE_MODULES   where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_WAREHOUSE_MODULES AS SELECT * FROM WB$_IV_WAREHOUSE_MODULES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_BUSINESS_DEF_MODULES AS SELECT * FROM WB$_IV_BUSINESS_DEF_MODULES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_GATEWAY_MODULES AS SELECT * FROM WB$_IV_GATEWAY_MODULES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_DATABASE_MODULES AS SELECT * FROM WB$_IV_DATABASE_MODULES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CMIV_MODULES AS SELECT * FROM WB$_IV_CMIV_MODULES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_PREDEFINED_MODULES AS SELECT * FROM WB$_IV_PREDEFINED_MODULES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_PACKAGED_APPS_MODULES AS SELECT * FROM WB$_IV_PACKAGED_APPS_MODULES   where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_EXTERNAL_TABLES AS SELECT * FROM WB$_IV_EXTERNAL_TABLES   where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_EXTERNAL_COLUMNS AS SELECT * FROM WB$_IV_EXTERNAL_COLUMNS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_UDO_MODULES AS SELECT * FROM WB$_IV_UDO_MODULES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_UDO_FCOS AS SELECT * FROM WB$_IV_UDO_FCOS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_PLATFORMS AS SELECT * FROM WB$_IV_PLATFORMS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CONFIG_TEMPLATE_SETS AS SELECT * FROM WB$_IV_CONFIG_TEMPLATE_SETS   where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CONFIG_TEMPLATES AS SELECT * FROM WB$_IV_CONFIG_TEMPLATES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_CLASS_DEFINITIONS AS SELECT * FROM WB$_IV_CLASS_DEFINITIONS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_PROPERTY_DEFINITIONS AS SELECT * FROM WB$_IV_PROPERTY_DEFINITIONS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_UDO_FOLDERS AS SELECT * FROM WB$_IV_UDO_FOLDERS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_UDO_SCOS AS SELECT * FROM WB$_IV_UDO_SCOS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_UDO_ASSOCIATIONS AS SELECT * FROM WB$_IV_UDO_ASSOCIATIONS  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_WEB_SERVICES AS SELECT * FROM WB$_IV_WEB_SERVICES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_WEB_SERVICE_PACKAGES AS SELECT * FROM WB$_IV_WEB_SERVICE_PACKAGES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;
CREATE OR REPLACE VIEW ALL_IV_APP_SERVER_MODULES AS SELECT * FROM WB$_IV_APP_SERVER_MODULES  where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de