解决问题RPE-02260:数据库用户owf_mgr必须是控制中心用户。

2023-12-03 05:30

本文主要是介绍解决问题RPE-02260:数据库用户owf_mgr必须是控制中心用户。,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

问题:

因为owf_mgr不是OWB用户,所以在部署进程流包时,提示如下错误:

RPE-02260: Database User OWF_MGR must be a Control Center User. Please use the OWB Design Client against the Control Center repository to grant the Control Center User role。

RPE-02260:数据库用户owf_mgr必须是控制中心用户。请针对控制中心资料档案库使用OWB Design Client ,授予其控制中心用户角色。

注释:the OWB Design Client against the Control Center repository中,against the Control Center repository是修饰the OWB Design Client的,故而Please use the OWB Design Client against the Control Center repository to grant the Control Center User role应翻译成“使用针对控制中心资料档案库OWB Design Client OWF_MGR用户授予控制中心用户角色”。因为OWB组件结构中,OWB Design Client (Designcenter)是要连接到一个工作区(这里指的是运行时工作区)上的,所以“针对”可以理解为“连接到”,所以翻译成“使用一个当前连接到运行时的控制中心资料档案库OWB Design Client OWF_MGR用户授予控制中心用户角色”。

假设一个名为PFPKG_1的进程流包下含有两个进程流,分别名为进程流_1进程流_2,则在控制中心(界面)上部署该进程流包失败时,查看它的作业详细资料如下:

名称                   操作          状态                           日志

PFPKG_1         创建          错误                            ora-01924:角色‘OWB_USER’未被授权或不存在                               //3

                                                                                  ora-06512:在“sys.dbms_session”,line   345,

                                                                                  ora-06512:在line   1                                                                                     //4

PFPKG_1         创建          错误                             RPE-02215:无法测试同义词PFPKG_1__WB_RTI_WORKFLOW_UTIL           //1

PFPKG_1         创建          错误                             RPE-02260:数据库用户owf_mgr必须是控制中心用户。请针对控制中心资料档案库使用 

                                                                                                         OWB Design Client,授予其控制中心用户角色。                    //2

进程流_1            创建          INFORMATIONAL     RPE-02071:因为以前报告的严重错误,部署已中止。                                       //0

进程流_2            创建          INFORMATIONAL         RPE-02071:因为以前报告的严重错误,部署已中止。                                    //0

对该作业详细资料的说明:

进程流包PFPKG_1 对应的脚本是PL/SQL脚本,在“sys.dbms_session”,line   345和line   1角色‘OWB_USER’未被授权或不存在,故而无法测试同义词PFPKG_1__WB_RTI_WORKFLOW_UTIL。而角色‘OWB_USER’未被授权或不存在的原因是数据库用户owf_mgr必须是控制中心用户。请针对控制中心资料档案库使用OWB Design Client,授予其控制中心用户角色。进程流_1进程流_2由于进程流包PFPKG_1的严重错误,部署已中止。


还有一种理解日志的顺序: //0 //1 //2 //3 //4

解决方法:



注释:Control Center User(控制中心用户)是OWB用户的另一种说法,两者指的是同一个概念。

Register the Oracle Workflow User(即使用OWB安全UI使owf_mgr称为OWB用户

You need to grant specific roles to the Oracle Workflow(OWF) user,owf_mgr, for it to have the privileges to execute a process flow in the Control Center(确切地说,是在控制中心进程注册到的工作区上。因为在部署时,owf_mgr要执行存放在该工作区上进程流对应的脚本).

You do not have to embed the password for the Control Center in database-links owned by the OWF user. The Control Center user is highly privileged(这里说的控制中心用户的权限也是属于数据库用户权限范围的) and its password is tightly controlled.

To register the OWF user, you use the Register Warehouse Builder Users wizard from the Security > Users node in Global Explorer panel. To get access to the security node, ensure you log in to the design center asthe repository owner(确切说是,工作区所有者用户,非owbsys这个用户,这个用户不能登录设计中心的).

1.

If not already logged in, log in to the Design Center with username/password asrep_owner/rep_owner.

In the Global Explorer panel, expand the Security node. Right-click theUsers node and selectNew.

Note: You must save or revert your changes before creating a new user. To save previous changes, selectSave All from the Design menu or click on the toolbar.

Place the cursor over this icon to see the image

The Create User dialog appears.

 

2.

On the Create User dialog, you can select from the available list of database users or create a new one that will be automatically registered as Warehouse Builder user.

Earlier in this lesson, where you were instructed to install Oracle Workflow Server, you were instructed to use the Oracle Workflow Configuration Assistant and specify owf_mgr as the Workflow Account. This resulted in the creation of owf_mgr as a database user. Select owf_mgr from the Available DB Users list and click> to move it to Selected Users list. ClickOK.

Place the cursor over this icon to see the image

Notice that owf_mgr user is added to the Security > Users node in the Global Explorer panel.

参考: Designing ETL Data Flow Mappings【OWB 11g Release 1】

解决在创建进程流位置是遇到的问题:连接成功,无法检索工作流版本


Register the Oracle Workflow User

You need to grant specific roles to the Oracle Workflow(OWF) user, owf_mgr, for it to have the privileges to execute a process flow in the Control Center.

The step of registering the Oracle Workflow user, owf_mgr, is because of the new security model. This new security model means that you do not have to embed the password for the Control Center in database-links owned by the OWF user. The Control Center user is highly privileged and its password is tightly controlled.

To register the OWF user, you use the Register Warehouse Builder Users wizard from the Security > Users node in Global Explorer panel. To get access to the security node, ensure you log in to the design center as the repository owner.


中文译文:

RPE-02260: Database User OWF_MGR must be a Control Center User. Please use the OWB Design Client against the Control Center repository to grant the Control Center User role.

您需要授予 Oracle Workflow (OWF) 用户 owf_mgr 特定角色,使其具有在 Control Center 中执行进程流的权限。
您不必将 Control Center 的口令嵌入 OWF 用户所拥有的数据库链接中。Control Center 用户具有高特权,其口令受到严格控制。
要注册 OWF 用户,可以从 Global Explorer 面板中的 Security > Users 节点使用 Register Warehouse Builder Users 向导。要访问 Security 节点,请确保以信息库所有者的身份登录到 Design Center。
1)
如果尚未登录,以用户名/口令 rep_owner/rep_owner 登录 Design Center。
在 Global Explorer 面板中展开 Security 节点。右键单击 Users 节点并选择 New。
注:在创建新用户之前,您必须先保存或恢复您的更改。要保存以前的更改,请从 Design 菜单中选择 Save All,或者单击工具栏中的
此时出现 Create User 对话框。

2)
在 Create User 对话框中,您可以从可用数据库用户列表中进行选择,也可以创建一个新用户,该用户将自动注册为 Warehouse Builder 用户。

在本教程前面的部分中,我们说明了如何安装 Oracle Workflow Server,如何使用 Oracle Workflow Configuration Assistant,以及如何将 owf_mgr 指定为工作流帐户。其结果是将 owf_mgr 创建为数据库用户。从 Available DB Users 列表中选择 owf_mgr,单击 > 将其移至 Selected Users 列表。单击 OK。

注意,owf_mgr 用户已添加到 Global Explorer 面板的 Security > Users 节点中。


参考:http://blog.csdn.net/kingzone_2008/article/details/8921970


来自oracle官方文档:

About the Security Service

Only users with administrative privileges can access the security service under Globals Navigator to manage users and roles of the security policy in Oracle Warehouse Builder API and Scripting Reference.

When you install Oracle Warehouse Builder and then use the Repository Assistant to create a design repository, Oracle Warehouse Builder makes the design repository owner the default administrator. The first time you start the Design Center after installation, you must log in as the design repository owner. You can then define additional administrators or other users as necessary.

When you log in to the Oracle Warehouse Builder Design Center as the design repository owner, it displays the Globals Navigator.

Description of globals_navigator.gif follows
Description of the illustration globals_navigator.gif

To view default security settings:

  1. In Globals Navigator, expand Security.

  2. Expand Users, and then expand Roles.

    Description of security_01.gif follows
    Description of the illustration security_01.gif

  3. Notice that there are two predefined roles, ADMINISTRATOR and EVERYONE.

  4. The one predefined user is the design repository owner; it is assigned the ADMINISTRATOR role by default.

    To view or edit the details for a user, in the globals Navigator, under Security and then under Users, select that and double-click the user. The Edit User screen appears.

    Description of security_02.gif follows
    Description of the illustration security_02.gif

For a complete list of all the tasks administrators can perform, see "Administrator Role".

参考:http://docs.oracle.com/cd/E11882_01/owb.112/e17130/security_mgmt.htm#WBINS15200

About the Security Service

Only users with administrative privileges can access the Security Service and change security policy in Oracle Warehouse Builder.

When you install Oracle Warehouse Builder and then use the Repository Assistant to create a design repository, Oracle Warehouse Builder assigns the design repository owner you define to be the default administrator. The first time you start the Design Center after installation, you must log in as the design repository owner. You can then define additional administrators or other users as necessary.

Log in to the Oracle Warehouse Builder Design Center as the design repository owner and Oracle Warehouse Builder displays the Globals Navigator.

Under the security node, there are two predefined roles,ADMINISTRATOR andEVERYONE. The one predefined user is the design repository owner,REPOS_OWNER in this example, which is assigned the ADMINISTRATOR role by default.

To perform actions under the Security node, select an object and right-click to view all of the possible operations. Or select an object and selectEdit from the menu bar.

See Also:

These topics in Oracle Warehouse Builder Installation and Administration Guide:
  • "Managing Security"

  • "Managing Configurations"

参考:http://docs.oracle.com/cd/E11882_01/owb.112/e10581/metadatamgt.htm#WBCON4639

这篇关于解决问题RPE-02260:数据库用户owf_mgr必须是控制中心用户。的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/448236

相关文章

mysql数据库重置表主键id的实现

《mysql数据库重置表主键id的实现》在我们的开发过程中,难免在做测试的时候会生成一些杂乱无章的SQL主键数据,本文主要介绍了mysql数据库重置表主键id的实现,具有一定的参考价值,感兴趣的可以了... 目录关键语法演示案例在我们的开发过程中,难免在做测试的时候会生成一些杂乱无章的SQL主键数据,当我们

Spring Boot 整合 MyBatis 连接数据库及常见问题

《SpringBoot整合MyBatis连接数据库及常见问题》MyBatis是一个优秀的持久层框架,支持定制化SQL、存储过程以及高级映射,下面详细介绍如何在SpringBoot项目中整合My... 目录一、基本配置1. 添加依赖2. 配置数据库连接二、项目结构三、核心组件实现(示例)1. 实体类2. Ma

查看Oracle数据库中UNDO表空间的使用情况(最新推荐)

《查看Oracle数据库中UNDO表空间的使用情况(最新推荐)》Oracle数据库中查看UNDO表空间使用情况的4种方法:DBA_TABLESPACES和DBA_DATA_FILES提供基本信息,V$... 目录1. 通过 DBjavascriptA_TABLESPACES 和 DBA_DATA_FILES

Java实现数据库图片上传与存储功能

《Java实现数据库图片上传与存储功能》在现代的Web开发中,上传图片并将其存储在数据库中是常见的需求之一,本文将介绍如何通过Java实现图片上传,存储到数据库的完整过程,希望对大家有所帮助... 目录1. 项目结构2. 数据库表设计3. 实现图片上传功能3.1 文件上传控制器3.2 图片上传服务4. 实现

mysql删除无用用户的方法实现

《mysql删除无用用户的方法实现》本文主要介绍了mysql删除无用用户的方法实现,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面随着小编来一起学习学习吧... 1、删除不用的账户(1) 查看当前已存在账户mysql> select user,host,pa

使用Dify访问mysql数据库详细代码示例

《使用Dify访问mysql数据库详细代码示例》:本文主要介绍使用Dify访问mysql数据库的相关资料,并详细讲解了如何在本地搭建数据库访问服务,使用ngrok暴露到公网,并创建知识库、数据库访... 1、在本地搭建数据库访问的服务,并使用ngrok暴露到公网。#sql_tools.pyfrom

Java实现数据库图片上传功能详解

《Java实现数据库图片上传功能详解》这篇文章主要为大家详细介绍了如何使用Java实现数据库图片上传功能,包含从数据库拿图片传递前端渲染,感兴趣的小伙伴可以跟随小编一起学习一下... 目录1、前言2、数据库搭建&nbsChina编程p; 3、后端实现将图片存储进数据库4、后端实现从数据库取出图片给前端5、前端拿到

IDEA连接达梦数据库的详细配置指南

《IDEA连接达梦数据库的详细配置指南》达梦数据库(DMDatabase)作为国产关系型数据库的代表,广泛应用于企业级系统开发,本文将详细介绍如何在IntelliJIDEA中配置并连接达梦数据库,助力... 目录准备工作1. 下载达梦JDBC驱动配置步骤1. 将驱动添加到IDEA2. 创建数据库连接连接参数

Jmeter如何向数据库批量插入数据

《Jmeter如何向数据库批量插入数据》:本文主要介绍Jmeter如何向数据库批量插入数据方式,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录Jmeter向数据库批量插入数据Jmeter向mysql数据库中插入数据的入门操作接下来做一下各个元件的配置总结Jmete

MySql中的数据库连接池详解

《MySql中的数据库连接池详解》:本文主要介绍MySql中的数据库连接池方式,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录mysql数据库连接池1、概念2、为什么会出现数据库连接池3、原理4、数据库连接池的提供商5、DataSource数据源6、DBCP7、C