---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;

grant execute on PUBLIC_VIEW_SEC_UTIL to %owb_user_role;