Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\grantPublicViewRole.sql
--this is the public view role,name convention:OWBR_repositorySchemaName --moved to secCreate.sql and protect it by password --CREATE ROLE %view_public_role; grant SELECT on ALL_IV_ALL_OBJECTS to %view_public_role; grant SELECT on ALL_IV_ATTR_GROUPS to %view_public_role; grant SELECT on ALL_IV_ATTR_GROUP_ITEM_USES to %view_public_role; --fix bug 5684278 now there is no publicview named all_iv_classificaation* --grant SELECT on ALL_IV_CLASSIFICATIONS to %view_public_role; --grant SELECT on ALL_IV_CLASSIFICATION_ITEMS to %view_public_role; grant SELECT on ALL_IV_COLUMNS to %view_public_role; grant SELECT on ALL_IV_CUBES to %view_public_role; grant SELECT on ALL_IV_CUBE_IMPLS to %view_public_role; grant SELECT on ALL_IV_CUBE_MEASURES to %view_public_role; grant SELECT on ALL_IV_CUBE_MEASURE_DIM_USES to %view_public_role; grant SELECT on ALL_IV_DIMENSIONS to %view_public_role; grant SELECT on ALL_IV_DIM_HIERARCHIES to %view_public_role; grant SELECT on ALL_IV_DIM_HIERARCHY_LEVELS to %view_public_role; grant SELECT on ALL_IV_DIM_IMPLS to %view_public_role; grant SELECT on ALL_IV_DIM_LEVELS to %view_public_role; grant SELECT on ALL_IV_DIM_ROLES to %view_public_role; grant SELECT on ALL_IV_DIM_ATTRIBUTES to %view_public_role; grant SELECT on ALL_IV_DIM_LEVEL_ATTRIBUTES to %view_public_role; grant SELECT on ALL_IV_FIELDS to %view_public_role; grant SELECT on ALL_IV_FILES to %view_public_role; grant SELECT on ALL_IV_FOREIGN_KEYS to %view_public_role; grant SELECT on ALL_IV_FUNCTIONS to %view_public_role; grant SELECT on ALL_IV_FUNCTION_IMPLS to %view_public_role; grant SELECT on ALL_IV_FUNCTION_LIBRARIES to %view_public_role; grant SELECT on ALL_IV_FUNCTION_PARAMETERS to %view_public_role; -- fix bug 5684278 grant SELECT on ALL_IV_IMPACT_DEPENDENTS to %view_public_role; grant SELECT on ALL_IV_INFORMATION_SYSTEMS to %view_public_role; grant SELECT on ALL_IV_INSTALLATIONS to %view_public_role; grant SELECT on ALL_IV_KEYS to %view_public_role; grant SELECT on ALL_IV_KEY_COLUMN_USES to %view_public_role; --fix bug 5684278 grant SELECT on ALL_IV_LINEAGE_DEPENDENTS to %view_public_role; grant SELECT on ALL_IV_MATERIALIZED_VIEWS to %view_public_role; grant SELECT on ALL_IV_MLS_OBJECTS to %view_public_role; grant SELECT on ALL_IV_OBJECT_CONFIGURATIONS to %view_public_role; grant SELECT on ALL_IV_OBJECT_PROPERTIES to %view_public_role; grant SELECT on ALL_IV_PROJECTS to %view_public_role; grant SELECT on ALL_IV_RECORDS to %view_public_role; grant SELECT on ALL_IV_SCHEMAS to %view_public_role; grant SELECT on ALL_IV_SEQUENCES to %view_public_role; grant SELECT on ALL_IV_SUPPORTED_LANGUAGES to %view_public_role; grant SELECT on ALL_IV_TABLES to %view_public_role; grant SELECT on ALL_IV_VIEWS to %view_public_role; grant SELECT on ALL_IV_WORKSPACES to %view_public_role; grant SELECT on ALL_IV_XFORM_MAPS to %view_public_role; grant SELECT on ALL_IV_XFORM_MAP_COMPONENTS to %view_public_role; grant SELECT on ALL_IV_XFORM_MAP_GROUPS to %view_public_role; grant SELECT on ALL_IV_XFORM_MAP_PARAMETERS to %view_public_role; grant SELECT on ALL_IV_XFORM_MAP_PROPERTIES to %view_public_role; grant SELECT on all_iv_xform_map_details to %view_public_role; -- not existing grant SELECT on IV_UTIL_PARAM_REFERENCE to %view_public_role; --add more for paris/tahoe... grant SELECT on ALL_IV_OBJECTS to %view_public_role; grant SELECT on ALL_IV_FOLDERS to %view_public_role; grant SELECT on ALL_IV_FLD_CONTAINED_OBJECTS to %view_public_role; grant SELECT on ALL_IV_FIRSTCLASS_OBJECTS to %view_public_role; grant SELECT on ALL_IV_MODULES to %view_public_role; grant SELECT on ALL_IV_CUBE_DIMENSIONS to %view_public_role; grant SELECT on ALL_IV_DIM_LEVEL_IMPLS to %view_public_role; grant SELECT on ALL_IV_RELATIONS to %view_public_role; grant SELECT on ALL_IV_CHECK_CONSTRAINTS to %view_public_role; grant SELECT on ALL_IV_CONSTRAINTS to %view_public_role; grant SELECT on ALL_IV_RECORD_FIELDS to %view_public_role; grant SELECT on ALL_IV_PROCEDURES to %view_public_role; grant SELECT on ALL_IV_DB_FUNCTIONS to %view_public_role; grant SELECT on ALL_IV_TABLE_FUNC_PROPERTIES to %view_public_role; --non exits grant SELECT on ALL_IV_MINING_MODELS to %view_public_role; grant SELECT on ALL_IV_COLLECTIONS to %view_public_role; grant SELECT on ALL_IV_COLLECTION_REFERENCES to %view_public_role; grant SELECT on ALL_IV_PROCESS_MODULES to %view_public_role; grant SELECT on ALL_IV_PROCESSES to %view_public_role; grant SELECT on ALL_IV_SUB_PROCESSES to %view_public_role; grant SELECT on ALL_IV_PACKAGES to %view_public_role; grant SELECT on ALL_IV_PROCESS_ACTIVITIES to %view_public_role; grant SELECT on ALL_IV_PROCESS_PARAMETERS to %view_public_role; grant SELECT on ALL_IV_PROCESS_TRANSITIONS to %view_public_role; grant select on ALL_IV_EXPERTS to %view_public_role; grant select on ALL_IV_EXPERT_MODULES to %view_public_role; grant select on ALL_IV_EXPERT_VARIABLES to %view_public_role; grant select on ALL_IV_EXPERT_PARAMETERS to %view_public_role; grant select on ALL_IV_EXPERT_TRANSITIONS to %view_public_role; grant select on ALL_IV_NESTED_EXPERTS to %view_public_role; grant select on ALL_IV_EXPERT_TASKS to %view_public_role; grant SELECT on ALL_IV_CTS to %view_public_role; grant SELECT on ALL_IV_CT_FOLDERS to %view_public_role; grant SELECT on ALL_IV_CT_VARIABLES to %view_public_role; grant SELECT on ALL_IV_CT_PARAMETERS to %view_public_role; grant SELECT on ALL_IV_CT_TRANSITIONS to %view_public_role; --fix bug 7562094 --grant SELECT on ALL_IV_NESTED_KMS to %view_public_role; grant SELECT on ALL_IV_CT_TASKS to %view_public_role; grant SELECT on ALL_IV_SAP_MODULES to %view_public_role; grant SELECT on ALL_IV_FILE_MODULES to %view_public_role; grant SELECT on ALL_IV_WAREHOUSE_MODULES to %view_public_role; grant SELECT on ALL_IV_BUSINESS_DEF_MODULES to %view_public_role; grant SELECT on ALL_IV_GATEWAY_MODULES to %view_public_role; grant SELECT on ALL_IV_CMIV_MODULES to %view_public_role; --grant select on OWB_XML_MODULES to %view_public_role; grant SELECT on ALL_IV_PREDEFINED_MODULES to %view_public_role; grant SELECT on ALL_IV_PACKAGED_APPS_MODULES to %view_public_role; grant SELECT on ALL_IV_EXTERNAL_TABLES to %view_public_role; grant SELECT on ALL_IV_EXTERNAL_COLUMNS to %view_public_role; grant select on ALL_IV_UDO_MODULES to %view_public_role; grant select on ALL_IV_UDO_FCOS to %view_public_role; grant select on ALL_IV_UDO_FOLDERS to %view_public_role; grant select on ALL_IV_UDO_SCOS to %view_public_role; grant select on ALL_IV_UDO_ASSOCIATIONS to %view_public_role; grant select on ALL_IV_DATABASE_MODULES to %view_public_role; -- from public_views2.sql grant SELECT on ALL_IV_TABLE_FUNCTIONS to %view_public_role; grant SELECT on ALL_IV_LOCATIONS to %view_public_role; grant SELECT on ALL_IV_CONNECTORS to %view_public_role; grant SELECT on ALL_IV_RUNTIME_REPOSITORIES to %view_public_role; grant SELECT on ALL_IV_CONTROL_CENTERS to %view_public_role; grant SELECT on ALL_IV_ADVANCED_QUEUES to %view_public_role; grant select on OWB_SQL_COLLECTIONS to %view_public_role; grant SELECT on ALL_IV_OBJECT_TYPES to %view_public_role; grant SELECT on ALL_IV_PLS_COLLECTIONS to %view_public_role; grant SELECT on ALL_IV_PLS_RECORDS to %view_public_role; grant SELECT on ALL_IV_REF_CURSORS to %view_public_role; grant SELECT on ALL_IV_ITEM_FOLDERS to %view_public_role; grant SELECT on ALL_IV_ITEMS to %view_public_role; grant SELECT on ALL_IV_ITEM_FORMULA_REFS to %view_public_role; grant SELECT on ALL_IV_CONDITIONS to %view_public_role; grant SELECT on ALL_IV_CONDITION_FORMULA_REFS to %view_public_role; grant SELECT on ALL_IV_JOINS to %view_public_role; grant SELECT on ALL_IV_JOIN_COMPONENTS to %view_public_role; grant SELECT on ALL_IV_ITEM_FOLDER_JOIN_USAGES to %view_public_role; --grant SELECT on ALL_IV_ITEM_FOLDER_DB_ENTITIES to %view_public_role; -- not exists --grant SELECT on ALL_IV_ITEM_FOLDER_FK_USAGES to %view_public_role; --grant SELECT on ALL_IV_ITEM_FOLDER_AGG_LEVELS to %view_public_role; grant SELECT on ALL_IV_BUSINESS_AREAS to %view_public_role; grant SELECT on ALL_IV_BUSINESS_AREA_FOLDERS to %view_public_role; --non exits grant SELECT on ALL_IV_BUSINESS_AREA_DRILLS to %view_public_role; grant SELECT on ALL_IV_DRILL_PATHS to %view_public_role; grant SELECT on ALL_IV_DRILL_LEVELS to %view_public_role; grant SELECT on ALL_IV_DRILL_LEVELS_DISTINCT to %view_public_role; grant SELECT on ALL_IV_DRILL_LEVEL_LINKS to %view_public_role; grant SELECT on ALL_IV_DRILL_LEVEL_ITEMS to %view_public_role; grant SELECT on ALL_IV_DRILL_LEVEL_KEYS to %view_public_role; grant SELECT on ALL_IV_DRILL_LEVEL_KEY_ITEMS to %view_public_role; grant SELECT on ALL_IV_DRILL_PATH_JOIN_USAGES to %view_public_role; grant SELECT on ALL_IV_LISTS_OF_VALUES to %view_public_role; grant SELECT on ALL_IV_ALTERNATIVE_SORT_ORDERS to %view_public_role; grant SELECT on ALL_IV_DRILLS_TO_DETAIL to %view_public_role; grant SELECT on ALL_IV_REGISTERED_FUNCTIONS to %view_public_role; grant SELECT on ALL_IV_DATA_RULE_MODULES to %view_public_role; grant SELECT on ALL_IV_DATA_RULES to %view_public_role; grant SELECT on ALL_IV_DATA_RULE_GROUPS to %view_public_role; grant SELECT on ALL_IV_DATA_RULE_ATTRIBUTES to %view_public_role; grant SELECT on ALL_IV_DATA_RULE_PROPERTIES to %view_public_role; grant SELECT on ALL_IV_DATA_RULE_DOMAINS to %view_public_role; grant SELECT on ALL_IV_DATA_RULE_USAGES to %view_public_role; grant SELECT on ALL_IV_DATA_RULE_GROUP_USAGES to %view_public_role; grant SELECT on ALL_IV_DATA_RULE_ATTR_USAGES to %view_public_role; --not exists grant SELECT on ALL_IV_DATA_AUDIT_MAPS to %view_public_role; --not exists grant SELECT on ALL_IV_DATA_AUDIT_OPERATORS to %view_public_role; grant SELECT on ALL_IV_CALENDAR_MODULES to %view_public_role; grant SELECT on ALL_IV_CALENDARS to %view_public_role; grant SELECT on ALL_IV_CALENDAR_SCHEDULES to %view_public_role; grant SELECT on ALL_IV_ACTIVITY_FOLDERS to %view_public_role; grant SELECT on ALL_IV_ACTIVITY_TEMPLATES to %view_public_role; grant SELECT on ALL_IV_PLUGGABLE_MAPS to %view_public_role; grant SELECT on ALL_IV_PLUGGABLE_MAP_LIBRARIES to %view_public_role; grant select on ALL_IV_PLUG_MAP_COMPONENTS to %view_public_role; grant select on ALL_IV_PLUG_MAP_PARAMETERS to %view_public_role; grant SELECT on ALL_IV_PROFILES to %view_public_role; grant SELECT on ALL_IV_PROFILE_OBJECTS to %view_public_role; grant SELECT on ALL_IV_PROFILE_COLUMNS to %view_public_role; grant SELECT on ALL_IV_PROFILE_UNIQUE_KEYS to %view_public_role; grant SELECT on ALL_IV_PROFILE_FOREIGN_KEYS to %view_public_role; grant SELECT on ALL_IV_PROFILE_KEY_COLUMN_USES to %view_public_role; grant SELECT on ALL_IV_PROFILE_DOMAIN_VALUES to %view_public_role; grant SELECT on ALL_IV_PROFILE_PATTERN_VALUES to %view_public_role; grant SELECT on ALL_IV_PROFILE_RULES to %view_public_role; grant SELECT on ALL_IV_FUNCTIONAL_DEPENDENCIES to %view_public_role; grant SELECT on ALL_IV_ROW_RELATIONSHIPS to %view_public_role; grant SELECT on ALL_IV_PF_CORRECTED_MODULES to %view_public_role; grant SELECT on ALL_IV_TM_MODULES to %view_public_role; grant SELECT on ALL_IV_TM_TABLESPACES to %view_public_role; grant SELECT on ALL_IV_TM_SCHEMAS to %view_public_role; grant SELECT on ALL_IV_TM_TABLESPACES to %view_public_role; grant SELECT on ALL_IV_VARRAYS to %view_public_role; grant SELECT on ALL_IV_NESTED_TABLES to %view_public_role; grant SELECT on ALL_IV_STREAMS_QUEUES to %view_public_role; grant SELECT on ALL_IV_ADVANCED_QUEUES to %view_public_role; grant SELECT on ALL_IV_QUEUES to %view_public_role; grant SELECT on ALL_IV_QUEUE_TABLES to %view_public_role; grant SELECT on ALL_IV_QUEUE_PROPAGATIONS to %view_public_role; --grant SELECT on ALL_IV_STREAMS_CAPTURE to %view_public_role; --not exists --grant SELECT on ALL_IV_CAPTURE_RELATIONS to %view_public_role; -- not exists grant SELECT on ALL_IV_CMIV_DEFINITIONS to %view_public_role; grant SELECT on ALL_IV_CMIV_VIEWS to %view_public_role; grant select on ALL_IV_ATTRIBUTE_SETS to %view_public_role; grant select on ALL_IV_ATTRIBUTES to %view_public_role; grant select on ALL_IV_INDEXES to %view_public_role; grant select on ALL_IV_INDEX_KEYS to %view_public_role; grant select on ALL_IV_INDEX_PARTITION_KEYS to %view_public_role; grant select on ALL_IV_INDEX_PARTITIONS to %view_public_role; grant select on ALL_IV_PARTITION_KEYS to %view_public_role; grant select on ALL_IV_PARTITIONS to %view_public_role; grant select on ALL_IV_SUBPARTITION_KEYS to %view_public_role; grant select on ALL_IV_SUBPARTITIONS to %view_public_role; grant select on ALL_IV_SUBPARTITION_TEMPLATES to %view_public_role; --apply grants to missing views Nov2008 grant SELECT on ALL_IV_APP_SERVER_MODULES to %view_public_role; grant SELECT on ALL_IV_CATALOG_FOLDER_DRILLS to %view_public_role; grant SELECT on ALL_IV_CATALOG_FOLDER_TABLES to %view_public_role; grant SELECT on ALL_IV_CATALOG_FOLDERS to %view_public_role; grant SELECT on ALL_IV_CLASS_DEFINITIONS to %view_public_role; grant SELECT on ALL_IV_CONFIG_TEMPLATE_SETS to %view_public_role; grant SELECT on ALL_IV_CONFIG_TEMPLATES to %view_public_role; grant SELECT on ALL_IV_CONFIGURATIONS to %view_public_role; grant SELECT on ALL_IV_EXT_OBJECT_PROPERTIES to %view_public_role; grant SELECT on ALL_IV_LOGICAL_TABLE_AGGLEVELS to %view_public_role; grant SELECT on ALL_IV_LOGICAL_TABLE_DBOBJECTS to %view_public_role; grant SELECT on ALL_IV_LOGICAL_TABLE_FK_USAGES to %view_public_role; grant SELECT on ALL_IV_LOGICAL_TABLES to %view_public_role; grant SELECT on ALL_IV_PLATFORMS to %view_public_role; grant SELECT on ALL_IV_PROCESS_VARIABLES to %view_public_role; grant SELECT on ALL_IV_PROPERTY_DEFINITIONS to %view_public_role; grant SELECT on ALL_IV_SCHEDULABLE to %view_public_role; grant SELECT on ALL_IV_WEB_SERVICE_PACKAGES to %view_public_role; grant SELECT on ALL_IV_WEB_SERVICES to %view_public_role; grant SELECT on ALL_IV_EXEC_UNITS to %view_public_role; grant SELECT on ALL_IV_EXEC_UNIT_CT_USES to %view_public_role; grant SELECT on ALL_IV_EXEC_UNIT_MAP_COMP_USES to %view_public_role; --security views grant SELECT on WBA_IV_ROLE_PRIVS to %view_public_role; grant SELECT on WBA_IV_ROLES to %view_public_role; grant SELECT on WBA_IV_USERS to %view_public_role; grant SELECT on WBA_IV_SYS_PRIVS to %view_public_role; grant SELECT on WBA_IV_OBJ_PRIVS to %view_public_role; --all genericxxx changed to udo_xxx grant SELECT on ALL_IV_UDO_MODULES to %view_public_role; grant SELECT on ALL_IV_UDO_FCOS to %view_public_role; grant SELECT on ALL_IV_UDO_FOLDERS to %view_public_role; grant SELECT on ALL_IV_UDO_SCOS to %view_public_role; grant SELECT on ALL_IV_UDO_ASSOCIATIONS to %view_public_role; grant select on PCTREE to %view_public_role; --grant select on OWB_COMPPARAM_MV to %view_public_role; grant execute on DEP_DATAFLOW to %view_public_role; grant execute on DEP_UTIL to %view_public_role; grant execute on DEP_GENERIC to %view_public_role; grant execute on DEP_DETAILMAP to %view_public_role; grant execute on DEP_DETAILPFLOW to %view_public_role; grant execute on DEP_OBJECT to %view_public_role; grant execute on DEP_OBJECTLIST to %view_public_role; grant select on PCTREE to %view_public_role; --grant select on OWB_COMPPARAM_MV to %view_public_role; --not exists
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de