CREATE OR REPLACE VIEW ALL_IV_TABLE_FUNCTIONS AS SELECT * FROM WB$_IV_TABLE_FUNCTIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_LOCATIONS AS SELECT * FROM WB$_IV_LOCATIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_CONNECTORS AS SELECT * FROM WB$_IV_CONNECTORS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_RUNTIME_REPOSITORIES AS SELECT * FROM WB$_IV_RUNTIME_REPOSITORIES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_CONTROL_CENTERS AS SELECT * FROM WB$_IV_CONTROL_CENTERS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; -- 'CREATE OR REPLACE VIEW ALL_IV_ADVANCED_QUEUES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW OWB_SQL_COLLECTIONS AS SELECT * FROM WB$_SQL_COLLECTIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; -- 'CREATE OR REPLACE VIEW ALL_IV_OBJECT_TYPES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PLS_COLLECTIONS AS SELECT * FROM WB$_IV_PLS_COLLECTIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PLS_RECORDS AS SELECT * FROM WB$_IV_PLS_RECORDS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW OWB_PLS_ROWTYPES AS SELECT * FROM WB$_PLS_ROWTYPES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_REF_CURSORS AS SELECT * FROM WB$_IV_REF_CURSORS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_ITEM_FOLDERS AS SELECT * FROM WB$_IV_ITEM_FOLDERS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_LOGICAL_TABLES AS SELECT * FROM WB$_IV_LOGICAL_TABLES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_ITEMS AS SELECT * FROM WB$_IV_ITEMS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_ITEM_FORMULA_REFS AS SELECT * FROM WB$_IV_ITEM_FORMULA_REFS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_CONDITIONS AS SELECT * FROM WB$_IV_CONDITIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_CONDITION_FORMULA_REFS AS SELECT * FROM WB$_IV_CONDITION_FORMULA_REFS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_JOINS AS SELECT * FROM WB$_IV_JOINS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_JOIN_COMPONENTS AS SELECT * FROM WB$_IV_JOIN_COMPONENTS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_ITEM_FOLDER_JOIN_USAGES AS SELECT * FROM WB$_IV_ITEM_FOLDER_JOIN_USAGES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_LOGICAL_TABLE_DBOBJECTS AS SELECT * FROM WB$_IV_LOGICAL_TABLE_DBOBJECTS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_LOGICAL_TABLE_FK_USAGES AS SELECT * FROM WB$_IV_LOGICAL_TABLE_FK_USAGES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_LOGICAL_TABLE_AGGLEVELS AS SELECT * FROM WB$_IV_LOGICAL_TABLE_AGGLEVELS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_BUSINESS_AREAS AS SELECT * FROM WB$_IV_BUSINESS_AREAS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_BUSINESS_AREA_FOLDERS AS SELECT * FROM WB$_IV_BUSINESS_AREA_FOLDERS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_CATALOG_FOLDERS AS SELECT * FROM WB$_IV_CATALOG_FOLDERS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_CATALOG_FOLDER_TABLES AS SELECT * FROM WB$_IV_CATALOG_FOLDER_TABLES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_CATALOG_FOLDER_DRILLS AS SELECT * FROM WB$_IV_CATALOG_FOLDER_DRILLS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DRILL_PATHS AS SELECT * FROM WB$_IV_DRILL_PATHS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DRILL_LEVELS AS SELECT * FROM WB$_IV_DRILL_LEVELS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DRILL_LEVELS_DISTINCT AS SELECT * FROM WB$_IV_DRILL_LEVELS_DISTINCT where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DRILL_LEVEL_LINKS AS SELECT * FROM WB$_IV_DRILL_LEVEL_LINKS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DRILL_LEVEL_ITEMS AS SELECT * FROM WB$_IV_DRILL_LEVEL_ITEMS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DRILL_LEVEL_KEYS AS SELECT * FROM WB$_IV_DRILL_LEVEL_KEYS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DRILL_LEVEL_KEY_ITEMS AS SELECT * FROM WB$_IV_DRILL_LEVEL_KEY_ITEMS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DRILL_PATH_JOIN_USAGES AS SELECT * FROM WB$_IV_DRILL_PATH_JOIN_USAGES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_LISTS_OF_VALUES AS SELECT * FROM WB$_IV_LISTS_OF_VALUES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_ALTERNATIVE_SORT_ORDERS AS SELECT * FROM WB$_IV_ALTERNATIVE_SORT_ORDERS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DRILLS_TO_DETAIL AS SELECT * FROM WB$_IV_DRILLS_TO_DETAIL where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_REGISTERED_FUNCTIONS AS SELECT * FROM WB$_IV_REGISTERED_FUNCTIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DATA_RULE_MODULES AS SELECT * FROM WB$_IV_DATA_RULE_MODULES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DATA_RULES AS SELECT * FROM WB$_IV_DATA_RULES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DATA_RULE_GROUPS AS SELECT * FROM WB$_IV_DATA_RULE_GROUPS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DATA_RULE_ATTRIBUTES AS SELECT * FROM WB$_IV_DATA_RULE_ATTRIBUTES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DATA_RULE_PROPERTIES AS SELECT * FROM WB$_IV_DATA_RULE_PROPERTIES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DATA_RULE_DOMAINS AS SELECT * FROM WB$_IV_DATA_RULE_DOMAINS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DATA_RULE_USAGES AS SELECT * FROM WB$_IV_DATA_RULE_USAGES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DATA_RULE_GROUP_USAGES AS SELECT * FROM WB$_IV_DATA_RULE_GROUP_USAGES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_DATA_RULE_ATTR_USAGES AS SELECT * FROM WB$_IV_DATA_RULE_ATTR_USAGES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; -- 'CREATE OR REPLACE VIEW ALL_IV_DATA_AUDIT_MAPS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; -- 'CREATE OR REPLACE VIEW ALL_IV_DATA_AUDIT_OPERATORS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_CALENDAR_MODULES AS SELECT * FROM WB$_IV_CALENDAR_MODULES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_CALENDARS AS SELECT * FROM WB$_IV_CALENDARS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_CALENDAR_SCHEDULES AS SELECT * FROM WB$_IV_CALENDAR_SCHEDULES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_ACTIVITY_FOLDERS AS SELECT * FROM WB$_IV_ACTIVITY_FOLDERS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_ACTIVITY_TEMPLATES AS SELECT * FROM WB$_IV_ACTIVITY_TEMPLATES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PLUGGABLE_MAPS AS SELECT * FROM WB$_IV_PLUGGABLE_MAPS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PLUGGABLE_MAP_LIBRARIES AS SELECT * FROM WB$_IV_PLUGGABLE_MAP_LIBRARIES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PLUG_MAP_COMPONENTS AS SELECT * FROM WB$_IV_PLUG_MAP_COMPONENTS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PLUG_MAP_PARAMETERS AS SELECT * FROM WB$_IV_PLUG_MAP_PARAMETERS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PROFILES AS SELECT * FROM WB$_IV_PROFILES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PROFILE_OBJECTS AS SELECT * FROM WB$_IV_PROFILE_OBJECTS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PROFILE_COLUMNS AS SELECT * FROM WB$_IV_PROFILE_COLUMNS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PROFILE_UNIQUE_KEYS AS SELECT * FROM WB$_IV_PROFILE_UNIQUE_KEYS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PROFILE_FOREIGN_KEYS AS SELECT * FROM WB$_IV_PROFILE_FOREIGN_KEYS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_FUNCTIONAL_DEPENDENCIES AS SELECT * FROM WB$_IV_FUNCTIONAL_DEPENDENCIES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_ROW_RELATIONSHIPS AS SELECT * FROM WB$_IV_ROW_RELATIONSHIPS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PROFILE_KEY_COLUMN_USES AS SELECT * FROM WB$_IV_PROFILE_KEY_COLUMN_USES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PROFILE_DOMAIN_VALUES AS SELECT * FROM WB$_IV_PROFILE_DOMAIN_VALUES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PROFILE_PATTERN_VALUES AS SELECT * FROM WB$_IV_PROFILE_PATTERN_VALUES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PROFILE_RULES AS SELECT * FROM WB$_IV_PROFILE_RULES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PF_CORRECTED_MODULES AS SELECT * FROM WB$_IV_PF_CORRECTED_MODULES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_TM_MODULES AS SELECT * FROM WB$_IV_TM_MODULES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_TM_TABLESPACES AS SELECT * FROM WB$_IV_TM_TABLESPACES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_TM_SCHEMAS AS SELECT * FROM WB$_IV_TM_SCHEMAS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_OBJECT_TYPES AS SELECT * FROM WB$_IV_OBJECT_TYPES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_VARRAYS AS SELECT * FROM WB$_IV_VARRAYS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_NESTED_TABLES AS SELECT * FROM WB$_IV_NESTED_TABLES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_STREAMS_QUEUES AS SELECT * FROM WB$_IV_STREAMS_QUEUES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_ADVANCED_QUEUES AS SELECT * FROM WB$_IV_ADVANCED_QUEUES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_QUEUES AS SELECT * FROM WB$_IV_QUEUES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_QUEUE_TABLES AS SELECT * FROM WB$_IV_QUEUE_TABLES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_QUEUE_PROPAGATIONS AS SELECT * FROM WB$_IV_QUEUE_PROPAGATIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; -- 'CREATE OR REPLACE VIEW ALL_IV_STREAMS_CAPTURE where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; -- 'CREATE OR REPLACE VIEW ALL_IV_CAPTURE_RELATIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_CMIV_DEFINITIONS AS SELECT * FROM WB$_IV_CMIV_DEFINITIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_CMIV_VIEWS AS SELECT * FROM WB$_IV_CMIV_VIEWS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; -- 'CREATE OR REPLACE VIEW ALL_IV_CHANGE_DATA_CAPTURES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_SCHEMAS AS SELECT * FROM WB$_IV_SCHEMAS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW WBA_IV_USERS AS SELECT * FROM WB$_IV_USERS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW WBA_IV_ROLES AS SELECT * FROM WB$_IV_ROLES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW WBA_IV_ROLE_PRIVS AS SELECT * FROM WB$_IV_ROLE_PRIVS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW WBA_IV_SYS_PRIVS AS SELECT * FROM WB$_IV_SYS_PRIVS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW WBA_IV_OBJ_PRIVS AS SELECT * FROM WB$_IV_OBJ_PRIVS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; -- the following two do not need the where clause since they have all info among wksp CREATE OR REPLACE VIEW ALL_IV_WORKSPACES AS SELECT * FROM WB$_IV_WORKSPACES; CREATE OR REPLACE VIEW ALL_IV_WORKSPACE_ASSIGNMENTS AS SELECT * FROM WB$_IV_WORKSPACE_ASSIGNMENTS; CREATE OR REPLACE VIEW ALL_IV_INDEXES AS SELECT * FROM WB$_IV_INDEXES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_INDEX_KEYS AS SELECT * FROM WB$_IV_INDEX_KEYS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_INDEX_PARTITION_KEYS AS SELECT * FROM WB$_IV_INDEX_PARTITION_KEYS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_INDEX_PARTITIONS AS SELECT * FROM WB$_IV_INDEX_PARTITIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PARTITION_KEYS AS SELECT * FROM WB$_IV_PARTITION_KEYS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_SUBPARTITION_KEYS AS SELECT * FROM WB$_IV_SUBPARTITION_KEYS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_PARTITIONS AS SELECT * FROM WB$_IV_PARTITIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_SUBPARTITION_TEMPLATES AS SELECT * FROM WB$_IV_SUBPARTITION_TEMPLATES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_SUBPARTITIONS AS SELECT * FROM WB$_IV_SUBPARTITIONS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_ATTRIBUTE_SETS AS SELECT * FROM WB$_IV_ATTRIBUTE_SETS where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0; CREATE OR REPLACE VIEW ALL_IV_ATTRIBUTES AS SELECT * FROM WB$_IV_ATTRIBUTES where wb_workspace_management.has_system_privilege_int('ACCESS_PUBLICVIEW_BROWSER') != 0;