---This file should contain all the privileges which need to ---neccearily be granted to owb_user_role. ----- grant some pkg to run namespace service grant EXECUTE on NamespaceServiceImpl to %owb_user_role; grant EXECUTE on TranslationUtilityImpl to %owb_user_role; --grant EXECUTE on uoid to %owb_user_role; --grant EXECUTE on UOIDgenerator to %owb_user_role; grant EXECUTE on UOIDgenerator to %owb_user_role; --grant EXECUTE on secClientHelper to %owb_user_role; ----- grant execute on the created type: ObjectUOIDArray --grant EXECUTE on ObjectUOIDArray to %owb_user_role; --grant EXECUTE on PRIVSLISTS to %owb_user_role; --grant EXECUTE on USERIDLIST to %owb_user_role; grant EXECUTE on SEC_STRINGLIST to %owb_user_role; grant EXECUTE on SEC_INTEGERLIST to %owb_user_role; --grant EXECUTE on SEC_CASCADETYPELIST to %owb_user_role; grant EXECUTE on SEC_OBJECTINFOLIST to %owb_user_role; grant EXECUTE on SEC_UOIDLIST to %owb_user_role; -- data profiling table used in ui grant SELECT, INSERT, DELETE, UPDATE on DROP_MISC_OBJECTS to %owb_user_role; ---needed by locking fix bug: 2540531 grant EXECUTE on OWB_LOCK to %owb_user_role; grant EXECUTE on WBSecurityServiceImpl to %owb_user_role; ---wbsecurityhelper is used to de/register user, used here for --non-repos owner owb admin can register owb user grant EXECUTE on WBSecurityHelper to %owb_user_role; grant EXECUTE on OWB_NUMBER_TABLE_TYPE to %owb_user_role; grant EXECUTE on OWBDeletion to %owb_user_role; grant EXECUTE on ModelService to %owb_user_role; --grant privs to name space tables grant SELECT, INSERT, DELETE, UPDATE on CMPALLFOLDERFCONAMES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on InputFcos to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on FullClassNameLookup to %owb_user_role; --grant privs to sequence to generate elementid grant SELECT on cwmseq to %owb_user_role; grant SELECT on user_sequences to %owb_user_role; grant SELECT on copy_seq to %owb_user_role; --grant privs to sequence used by model definition service grant SELECT on mmmseq to %owb_user_role; grant SELECT on dblinkname_seq to %owb_user_role; --grant role to execute some proc from run-time repos(so that owb --admin can grant ctrl center role to other users grant EXECUTE on wb_rti_target_schema_privs to %owb_user_role; -- (duplicate grant) grant EXECUTE on wb_rti_target_schema_privs; -- FJK - from Oslo xbranchmerge ----start of MMM's introduced views grant SELECT, INSERT, DELETE, UPDATE on DefinitionElement_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on LoadingStrategy_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on AssociationDefinition_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DependencyDefinition_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on ClassDefinition_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on PropertyDefinition_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on ClassInheritanceDefinition_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on ClassUsageDefinition_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on ComponentDefinition_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DefinitionKeyLookupBundle_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on InterestSet_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DummyInterestSet_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on VerticalTree_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on PublicAPISet_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on InterestUsage_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DummyInterestUsage_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on TreeNode_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DefinitionInterestUsage_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on PropertyGroupDefinition_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on PropertySetDefinition_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on PropertyUsageChoice_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on PropertyUsageDefinition_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on RoleDefinition_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBAbstractType_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBScalarType_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBPrimitiveType_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBDomain_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBCollectionType_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBArrayType_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBExtensibleType_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBRange_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBProperty_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBCollectionProperty_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBArrayProperty_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBPrimitiveProperty_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBReferenceProperty_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBScalarProperty_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DefinitionElement_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on LoadingStrategy_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on AssociationDefinition_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DependencyDefinition_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on ClassDefinition_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on PropertyDefinition_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on ClassInheritanceDefinition_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on ClassUsageDefinition_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on ComponentDefinition_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DefinitionKeyLookupBundle_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on InterestSet_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DummyInterestSet_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on VerticalTree_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on PublicAPISet_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on InterestUsage_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DummyInterestUsage_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on TreeNode_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DefinitionInterestUsage_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on PropertyGroupDefinition_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on PropertySetDefinition_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on PropertyUsageChoice_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on PropertyUsageDefinition_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on RoleDefinition_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBAbstractType_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBScalarType_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBPrimitiveType_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBDomain_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBCollectionType_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBArrayType_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBExtensibleType_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBRange_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBProperty_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBCollectionProperty_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBArrayProperty_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBPrimitiveProperty_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBReferenceProperty_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBScalarProperty_X to %owb_user_role; -------start of MCM granting of privileges------------ --grant SELECT, INSERT, DELETE, UPDATE on CMPStorage to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on MCMModelSemantics to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on FCOFOLDERNamespaceStorage to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPALLFOLDERFCONAMES_X to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on MCMSemantics to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on changeLog to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on changeLogdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on pctree to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on TempProperties to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on pctreestorage to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on pctreedebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on interlink to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on interlinkstorage to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on interlinkdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on intralink to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on intralinkstorage to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on intralinkdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on SnapshotLookup to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on SnapshotLookupdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on SnapshotLookupTemp to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on SnapshotLookupTempdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on temptable to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on temptabledebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on SourceComponent to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on SourceComponentdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on TargetComponent to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on TargetComponentdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CompareStore to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on CompareStoredebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CompareStoreTemp to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on CompareStoreTempdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CompareStoreManager to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on CompareStoreManagerdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CompareStoreManagerTemp to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on CompareStoreManagerTempdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on TempFCO to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on TempFCOdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on MCMComponent to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on MCMComponentdebug to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on AutoRecovery to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on AutoRecoverydebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on HierarchyTable to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on HierarchyTableStorage to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on HierarchyTableDebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on SnapshotStoreTable to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on SnapshotStoreTableDebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on LWContext to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on LWContextdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on LWContextTemp to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on LWContextTempdebug to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on lwgraph to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on lwgraphtemp to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on lwcomptree to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on lwcomptreetemp to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on owb_error_log_table to %owb_user_role; -- this needs to be generated eventually grant SELECT, INSERT, DELETE, UPDATE on cmpelement to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on firstclassobject to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on secondclassobject to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on cmpfunction to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on cmpreferencepropertyvalue to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on cmpwbproject to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on cmpphysicalobject to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on owb_error_log_table to %owb_user_role; grant SELECT on SnapshotSequence to %owb_user_role; grant SELECT on SnapshotSequenceTemp to %owb_user_role; grant SELECT on CompareSequence to %owb_user_role; grant SELECT on CompareSequenceTemp to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on MCMErrors to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on errors to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on call_stacks to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on error_stacks to %owb_user_role; grant SELECT on error_seq to %owb_user_role; grant EXECUTE on Snapshot to %owb_user_role; grant EXECUTE on SnapshotCreateRestore to %owb_user_role; --grant EXECUTE on SnapshotCustom to %owb_user_role; grant EXECUTE on SnapshotGenerated to %owb_user_role; grant EXECUTE on SnapshotTrigger to %owb_user_role; grant EXECUTE on SnapshotError to %owb_user_role; grant EXECUTE on SnapshotImport to %owb_user_role; grant EXECUTE on SnapshotMXS to %owb_user_role; --grant EXECUTE on ErrorPkg to %owb_user_role; ------------end of MCM grantings----------------------------- ------- grant Relational Schema Enhancement view privileges ------------ grant SELECT, INSERT, UPDATE, DELETE ON CMPFCOElement_V to %owb_user_role; grant SELECT, INSERT, UPDATE, DELETE ON CMPFCOElement_X to %owb_user_role; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOElement_V to %owb_user_role; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOElement_X to %owb_user_role; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOCfgElement_V to %owb_user_role; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOCfgElement_X to %owb_user_role; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOMapElement_V to %owb_user_role; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOMapElement_X to %owb_user_role; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOPrpElement_V to %owb_user_role; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOPrpElement_X to %owb_user_role; grant SELECT, INSERT, UPDATE, DELETE ON CMPSYSElement_V to %owb_user_role; grant SELECT, INSERT, UPDATE, DELETE ON CMPSYSElement_X to %owb_user_role; ------- end of Relational Schema Enhancement view privileges ------------ ------- grant additional table privileges ------------ ------- to support gather schema stats if ------------ ------- user is not a repository owner --------------- ------- Bug 4084225: Try to eliminate other grants for gather schema stats grant EXECUTE on OptimizerStatistics to %owb_user_role; ------- End Bug 4084225 ------------------------------ grant SELECT, INSERT, DELETE, UPDATE on CLASSIFICATION_STORE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPFCOCLASSES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPFCOSTORAGE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPMMMCLASSES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPMMMSTORAGE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOCFGCLASSES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOCFGSTORAGE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOCLASSES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOSTORAGE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOMAPCLASSES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOMAPSTORAGE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOPRPCLASSES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOPRPSTORAGE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPSYSCLASSES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on CMPSYSSTORAGE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on FCOFOLDERNAMESPACE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on HIERARCHYREFTABLE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on HIERARCHYROOTS to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on OBJECTCONTEXTTREE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on OBJECTHIERARCHYTABLE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on OWB_ROLE_INFO to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on OWB_UTIL_CONFIGGROUPS to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on OWB_UTIL_CONFIGPARAMS to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on OWB_UTIL_LANGUAGES to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_ADMINISTRATORS to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_APP_RENDERERS to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_APP_REPOS_VERSIONS to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_APPLICATIONS to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_ERRORS to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_GROUP_PORTLETS to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_GROUP_REPOSITORIES to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_GROUP_ROLES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on OWBB_IMAGES to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_NAVIGATION_FAVORITES to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_PREFERENCES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on OWBB_QUERIES to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_REPORT_FAVORITES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on OWBB_REPORTS to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_REPOS_TYPES to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_REPOSITORIES to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_ROLE_QUERIES to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_ROLE_REPORTS to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_ROLES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on OWBB_TYPE_ALIASES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on OWBB_TYPES to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_USER_PORTLETS to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_USER_REPOSITORIES to %owb_user_role; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_USER_ROLES to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on RESERVATION_STORE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on TRANSLATIONTEMP to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on UOIDERRORTABLE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on UOIDREFERENCETABLE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on UOIDREFERENCETARGETTABLE to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on WBALLPROPERTIES to %owb_user_role; ------- end gather schema stats grants --------------- --Enable OWB Browser client---- folloiwng wmpxxx not exists anymore --grant execute on wmp_launcher_portlet to %owb_user_role; --grant execute on wmp_navigator_portlet to %owb_user_role; --grant execute on wmp_reports_portlet to %owb_user_role; --grant execute on wmp_favorites_portlet to %owb_user_role; --grant execute on wmp_administrator_portlet to %owb_user_role; --grant execute on wmp_pages to %owb_user_role; --grant execute on wmp_api_call to %owb_user_role; --grant execute on wmp_favorites_pages to %owb_user_role; --grant execute on wmp_administration_pages to %owb_user_role; --grant execute on wmp_api_doc to %owb_user_role; --grant execute on wmp_api_favorites to %owb_user_role; --grant execute on wmp_lia to %owb_user_role; --grant execute on lia_client to %owb_user_role; --grant select on wmp_binary_docs to %owb_user_role; --grant execute on wmp_portal to %owb_user_role; ---sochen grant execute on ManagePrivilegeFromDB to %owb_user_role; grant execute on SecurityCheckCascade to %owb_user_role; -----start of dependency liage by micheal fan------------ ---data liage added some new obj types----- --3 datatypes grant EXECUTE on PrecedenceObjList to %owb_user_role; grant EXECUTE on DEP_OBJECT to %owb_user_role; grant EXECUTE on DEP_OBJECTLIST to %owb_user_role; --5 pkg grant EXECUTE on DEP_DATAFLOW to %owb_user_role; grant EXECUTE on DEP_DETAILMAP to %owb_user_role; grant EXECUTE on DEP_DETAILPFLOW to %owb_user_role; grant EXECUTE on DEP_GENERIC to %owb_user_role; grant EXECUTE on DEP_UTIL to %owb_user_role; --3 view,1 tab grant SELECT, INSERT, DELETE, UPDATE on DATAFLOW_DEPENDENCY_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DEPLOYMENT_DEPENDENCY_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on STRUCTURAL_DEPENDENCY_V to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on DATAFLOW_DEPENDENCY_T to %owb_user_role; -----end of dependency liage by micheal fan------------- ---add some by philip ----- grant EXECUTE on owb_client_values to %owb_user_role; ---add some by sochen for public view read priv filter project---- grant SELECT, INSERT, DELETE, UPDATE on FCO_READ_LOOKUP to %owb_user_role; grant SELECT, INSERT, DELETE, UPDATE on FCO_READ_LOOKUP_V to %owb_user_role; grant execute on SECURITY_PV_UTILITIES to %owb_user_role; -- bug 5330707 - Needed for uninstallation of Data Profile Schema grant SELECT, INSERT, DELETE, UPDATE on DROP_MISC_OBJECTS to %owb_user_role; -- end bug 5330707 -- bug 5568194 - Needed for administrative tasks. grant EXECUTE on wb_rti_target_schema_privs to %owb_user_role; grant EXECUTE on wb_rt_target_schema_objs to %owb_user_role; -- end bug 5568194 grant execute on OWB_WORKSPACE_MANAGER to %owb_user_role; --fix bug 5937271 grant select on CWMSEQ to %owb_user_role; --added by swzhou @ 090324 for license check feature grant SELECT, INSERT, DELETE, UPDATE on OWB_LICENSE_PERMISSION to %owb_user_role;