Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\grantRoleObjPrivs_owbmetatest.sql
---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$CLIENT; grant EXECUTE on TranslationUtilityImpl to OWB$CLIENT; --grant EXECUTE on uoid to OWB$CLIENT; --grant EXECUTE on UOIDgenerator to OWB$CLIENT; grant EXECUTE on UOIDgenerator to OWB$CLIENT; --grant EXECUTE on secClientHelper to OWB$CLIENT; ----- grant execute on the created type: ObjectUOIDArray --grant EXECUTE on ObjectUOIDArray to OWB$CLIENT; --grant EXECUTE on PRIVSLISTS to OWB$CLIENT; --grant EXECUTE on USERIDLIST to OWB$CLIENT; grant EXECUTE on SEC_STRINGLIST to OWB$CLIENT; grant EXECUTE on SEC_INTEGERLIST to OWB$CLIENT; --grant EXECUTE on SEC_CASCADETYPELIST to OWB$CLIENT; grant EXECUTE on SEC_OBJECTINFOLIST to OWB$CLIENT; grant EXECUTE on SEC_UOIDLIST to OWB$CLIENT; -- data profiling table used in ui --grant SELECT, INSERT, DELETE, UPDATE on DROP_MISC_OBJECTS to OWB$CLIENT; ---needed by locking fix bug: 2540531 grant EXECUTE on OWB_LOCK to OWB$CLIENT; grant EXECUTE on WBSecurityServiceImpl to OWB$CLIENT; ---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$CLIENT; grant EXECUTE on ModelService to OWB$CLIENT; --grant privs to name space tables grant SELECT, INSERT, DELETE, UPDATE on CMPALLFOLDERFCONAMES to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on InputFcos to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on FullClassNameLookup to OWB$CLIENT; --grant privs to sequence to generate elementid grant SELECT on cwmseq to OWB$CLIENT; grant SELECT on user_sequences to OWB$CLIENT; grant SELECT on copy_seq to OWB$CLIENT; --grant privs to sequence used by model definition service grant SELECT on mmmseq to OWB$CLIENT; grant SELECT on dblinkname_seq to OWB$CLIENT; --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$CLIENT; -- (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$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on LoadingStrategy_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on AssociationDefinition_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on DependencyDefinition_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on ClassDefinition_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on PropertyDefinition_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on ClassInheritanceDefinition_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on ClassUsageDefinition_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on ComponentDefinition_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on DefinitionKeyLookupBundle_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on InterestSet_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on DummyInterestSet_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on VerticalTree_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on PublicAPISet_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on InterestUsage_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on DummyInterestUsage_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on TreeNode_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on DefinitionInterestUsage_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on PropertyGroupDefinition_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on PropertySetDefinition_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on PropertyUsageChoice_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on PropertyUsageDefinition_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on RoleDefinition_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBAbstractType_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBScalarType_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBPrimitiveType_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBDomain_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBCollectionType_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBArrayType_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBExtensibleType_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBRange_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBProperty_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBCollectionProperty_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBArrayProperty_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBPrimitiveProperty_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBReferenceProperty_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBScalarProperty_V to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on DefinitionElement_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on LoadingStrategy_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on AssociationDefinition_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on DependencyDefinition_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on ClassDefinition_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on PropertyDefinition_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on ClassInheritanceDefinition_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on ClassUsageDefinition_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on ComponentDefinition_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on DefinitionKeyLookupBundle_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on InterestSet_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on DummyInterestSet_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on VerticalTree_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on PublicAPISet_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on InterestUsage_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on DummyInterestUsage_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on TreeNode_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on DefinitionInterestUsage_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on PropertyGroupDefinition_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on PropertySetDefinition_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on PropertyUsageChoice_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on PropertyUsageDefinition_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on RoleDefinition_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBAbstractType_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBScalarType_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBPrimitiveType_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBDomain_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBCollectionType_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBArrayType_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBExtensibleType_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBRange_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBProperty_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBCollectionProperty_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBArrayProperty_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBPrimitiveProperty_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBReferenceProperty_X to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBScalarProperty_X to OWB$CLIENT; -------start of MCM granting of privileges------------ grant SELECT, INSERT, DELETE, UPDATE on CMPStorage to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on MCMModelSemantics to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on FCOFOLDERNamespaceStorage to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPALLFOLDERFCONAMES_X to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on MCMSemantics to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on changeLog to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on changeLogdebug to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on pctree to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on TempProperties to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on pctreestorage to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on pctreedebug to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on interlink to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on interlinkstorage to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on interlinkdebug to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on intralink to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on intralinkstorage to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on intralinkdebug to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on SnapshotLookup to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on SnapshotLookupdebug to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on SnapshotLookupTemp to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on SnapshotLookupTempdebug to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on temptable to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on temptabledebug to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on SourceComponent to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on SourceComponentdebug to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on TargetComponent to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on TargetComponentdebug to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on CompareStore to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on CompareStoredebug to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on CompareStoreTemp to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on CompareStoreTempdebug to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on CompareStoreManager to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on CompareStoreManagerdebug to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on CompareStoreManagerTemp to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on CompareStoreManagerTempdebug to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on TempFCO to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on TempFCOdebug to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on MCMComponent to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on MCMComponentdebug to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on AutoRecovery to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on AutoRecoverydebug to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on HierarchyTable to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on HierarchyTableStorage to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on HierarchyTableDebug to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on SnapshotStoreTable to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on SnapshotStoreTableDebug to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on LWContext to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on LWContextdebug to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on LWContextTemp to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on LWContextTempdebug to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on lwgraph to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on lwgraphtemp to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on lwcomptree to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on lwcomptreetemp to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on owb_error_log_table to OWB$CLIENT; -- this needs to be generated eventually grant SELECT, INSERT, DELETE, UPDATE on cmpelement to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on firstclassobject to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on secondclassobject to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on cmpfunction to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on cmpreferencepropertyvalue to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on cmpwbproject to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on cmpphysicalobject to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on owb_error_log_table to OWB$CLIENT; grant SELECT on SnapshotSequence to OWB$CLIENT; grant SELECT on SnapshotSequenceTemp to OWB$CLIENT; grant SELECT on CompareSequence to OWB$CLIENT; grant SELECT on CompareSequenceTemp to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on MCMErrors to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on errors to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on call_stacks to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on error_stacks to OWB$CLIENT; grant SELECT on error_seq to OWB$CLIENT; grant EXECUTE on Snapshot to OWB$CLIENT; grant EXECUTE on SnapshotCreateRestore to OWB$CLIENT; grant EXECUTE on SnapshotCustom to OWB$CLIENT; -- grant EXECUTE on SnapshotGenerated to OWB$CLIENT; -- grant EXECUTE on SnapshotTrigger to OWB$CLIENT; grant EXECUTE on SnapshotError to OWB$CLIENT; grant EXECUTE on SnapshotImport to OWB$CLIENT; grant EXECUTE on SnapshotMXS to OWB$CLIENT; --grant EXECUTE on ErrorPkg to OWB$CLIENT; ------------end of MCM grantings----------------------------- ------- grant Relational Schema Enhancement view privileges ------------ grant SELECT, INSERT, UPDATE, DELETE ON CMPFCOElement_V to OWB$CLIENT; grant SELECT, INSERT, UPDATE, DELETE ON CMPFCOElement_X to OWB$CLIENT; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOElement_V to OWB$CLIENT; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOElement_X to OWB$CLIENT; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOCfgElement_V to OWB$CLIENT; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOCfgElement_X to OWB$CLIENT; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOMapElement_V to OWB$CLIENT; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOMapElement_X to OWB$CLIENT; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOPrpElement_V to OWB$CLIENT; grant SELECT, INSERT, UPDATE, DELETE ON CMPSCOPrpElement_X to OWB$CLIENT; grant SELECT, INSERT, UPDATE, DELETE ON CMPSYSElement_V to OWB$CLIENT; grant SELECT, INSERT, UPDATE, DELETE ON CMPSYSElement_X to OWB$CLIENT; ------- 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$CLIENT; ------- End Bug 4084225 ------------------------------ grant SELECT, INSERT, DELETE, UPDATE on CLASSIFICATION_STORE to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPFCOCLASSES to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPFCOSTORAGE to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPMMMCLASSES to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPMMMSTORAGE to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOCFGCLASSES to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOCFGSTORAGE to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOCLASSES to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOSTORAGE to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOMAPCLASSES to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOMAPSTORAGE to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOPRPCLASSES to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPSCOPRPSTORAGE to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPSYSCLASSES to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on CMPSYSSTORAGE to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on FCOFOLDERNAMESPACE to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on HIERARCHYREFTABLE to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on HIERARCHYROOTS to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on OBJECTCONTEXTTREE to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on OBJECTHIERARCHYTABLE to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on OWB_ROLE_INFO to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on OWB_UTIL_CONFIGGROUPS to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on OWB_UTIL_CONFIGPARAMS to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on OWB_UTIL_LANGUAGES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_ADMINISTRATORS to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_APP_RENDERERS to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_APP_REPOS_VERSIONS to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_APPLICATIONS to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_ERRORS to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_GROUP_PORTLETS to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_GROUP_REPOSITORIES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_GROUP_ROLES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_IMAGES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_NAVIGATION_FAVORITES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_PREFERENCES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_QUERIES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_REPORT_FAVORITES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_REPORTS to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_REPOS_TYPES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_REPOSITORIES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_ROLE_QUERIES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_ROLE_REPORTS to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_ROLES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_TYPE_ALIASES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_TYPES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_USER_PORTLETS to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_USER_REPOSITORIES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on OWBB_USER_ROLES to OWB$CLIENT; --grant SELECT, INSERT, DELETE, UPDATE on RESERVATION_STORE to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on TRANSLATIONTEMP to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on UOIDERRORTABLE to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on UOIDREFERENCETABLE to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on UOIDREFERENCETARGETTABLE to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on WBALLPROPERTIES to OWB$CLIENT; ------- end gather schema stats grants --------------- --Enable OWB Browser client---- -- grant execute on wmp_launcher_portlet to OWB$CLIENT; -- grant execute on wmp_navigator_portlet to OWB$CLIENT; -- grant execute on wmp_reports_portlet to OWB$CLIENT; -- grant execute on wmp_favorites_portlet to OWB$CLIENT; -- grant execute on wmp_administrator_portlet to OWB$CLIENT; -- grant execute on wmp_pages to OWB$CLIENT; -- grant execute on wmp_api_call to OWB$CLIENT; -- grant execute on wmp_favorites_pages to OWB$CLIENT; -- grant execute on wmp_administration_pages to OWB$CLIENT; -- grant execute on wmp_api_doc to OWB$CLIENT; -- grant execute on wmp_api_favorites to OWB$CLIENT; -- grant execute on wmp_lia to OWB$CLIENT; -- grant execute on lia_client to OWB$CLIENT; -- grant select on wmp_binary_docs to OWB$CLIENT; -- grant execute on wmp_portal to OWB$CLIENT; ---sochen grant execute on ManagePrivilegeFromDB to OWB$CLIENT; grant execute on SecurityCheckCascade to OWB$CLIENT; -----start of dependency liage by micheal fan------------ ---data liage added some new obj types----- --3 datatypes -- grant EXECUTE on PrecedenceObjList to OWB$CLIENT; -- grant EXECUTE on DEP_OBJECT to OWB$CLIENT; -- grant EXECUTE on DEP_OBJECTLIST to OWB$CLIENT; --5 pkg -- grant EXECUTE on DEP_DATAFLOW to OWB$CLIENT; -- grant EXECUTE on DEP_DETAILMAP to OWB$CLIENT; -- grant EXECUTE on DEP_DETAILPFLOW to OWB$CLIENT; -- grant EXECUTE on DEP_GENERIC to OWB$CLIENT; -- grant EXECUTE on DEP_UTIL to OWB$CLIENT; --3 view,1 tab -- grant SELECT, INSERT, DELETE, UPDATE on DATAFLOW_DEPENDENCY_V to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on DEPLOYMENT_DEPENDENCY_V to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on STRUCTURAL_DEPENDENCY_V to OWB$CLIENT; -- grant SELECT, INSERT, DELETE, UPDATE on DATAFLOW_DEPENDENCY_T to OWB$CLIENT; -----end of dependency liage by micheal fan------------- ---add some by philip ----- ----grant EXECUTE on owb_client_values to OWB$CLIENT; ---add some by sochen for public view read priv filter project---- grant SELECT, INSERT, DELETE, UPDATE on FCO_READ_LOOKUP to OWB$CLIENT; grant SELECT, INSERT, DELETE, UPDATE on FCO_READ_LOOKUP_V to OWB$CLIENT; -- grant execute on SECURITY_PV_UTILITIES to OWB$CLIENT; -- bug 5330707 - Needed for uninstallation of Data Profile Schema -- grant SELECT, INSERT, DELETE, UPDATE on DROP_MISC_OBJECTS to OWB$CLIENT; -- end bug 5330707 -- bug 5568194 - Needed for administrative tasks. -- grant EXECUTE on wb_rti_target_schema_privs to OWB$CLIENT; -- grant EXECUTE on wb_rt_target_schema_objs to OWB$CLIENT; -- end bug 5568194 grant execute on OWB_WORKSPACE_MANAGER to OWB$CLIENT;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de