Oracle 数据库作业运行问题-ora01031，权限不足 ora06512

发布于 2025-01-16 01:42:03 字数 1077 浏览 2 评论 0原文

我对 Oracle 很陌生，不太了解如何解决这个问题。

我有两个架构 ERM22_TEST 和 ERM22_TEST_CUSTOM

RM22_TEST.ASYNC_JOB_QUEUE_COMMAND_BAS 中存在一个包和 ERM22_TEST_CUSTOM.C_PSP_INTERFACE 中的另一个包

我在 ERM22_TEST_CUSTOM 模式中有一个作业调度程序，它将数据从视图导出到 CSV 文件，但是当我单击运行作业时，它给了我错误

ORA-01031: insufficient privileges
ORA-06512: at "ERM22_TEST.ASYNC_JOB_QUEUE_COMMAND_BAS", line 101
ORA-06512: at "ERM22_TEST.ASYNC_JOB_QUEUE_COMMAND_BAS", line 106
ORA-06512: at "ERM22_TEST_CUSTOM.C_PSP_INTERFACE", line 39
ORA-06512: at "ERM22_TEST_CUSTOM.C_PSP_INTERFACE", line 95

：我从应用程序中导出的数据与导出 csv 文件中的数据相同。运行数据库作业和从应用程序客户端运行作业的两个用户名不同。

我只知道它在授予访问权限方面存在一些问题，但我不知道如何授予对在另一个模式 ERM22_TEST 中运行包的 ERM22_TEST_CUSTOM 模式的访问权限。

ORA-01031: insufficient privileges
ORA-06512: at "ERM22_TEST.ASYNC_JOB_QUEUE_COMMAND_BAS", line 101
ORA-06512: at "ERM22_TEST.ASYNC_JOB_QUEUE_COMMAND_BAS", line 106
ORA-06512: at "ERM22_TEST_CUSTOM.C_PSP_INTERFACE", line 39
ORA-06512: at "ERM22_TEST_CUSTOM.C_PSP_INTERFACE", line 95

原文

I am very new to oracle and dont have much of an idea of how to resolve this problem.

I have two schema ERM22_TEST and ERM22_TEST_CUSTOM

One package exists in RM22_TEST.ASYNC_JOB_QUEUE_COMMAND_BAS
and another package in ERM22_TEST_CUSTOM.C_PSP_INTERFACE

I have a job scheduler in ERM22_TEST_CUSTOM schema, which exports the data from a view in to CSV file, but when I click on run job it gives me the error:

ORA-01031: insufficient privileges
ORA-06512: at "ERM22_TEST.ASYNC_JOB_QUEUE_COMMAND_BAS", line 101
ORA-06512: at "ERM22_TEST.ASYNC_JOB_QUEUE_COMMAND_BAS", line 106
ORA-06512: at "ERM22_TEST_CUSTOM.C_PSP_INTERFACE", line 39
ORA-06512: at "ERM22_TEST_CUSTOM.C_PSP_INTERFACE", line 95

But it same export I do form my application than it export the data in csv file. Both user name are not same which run the database job and run the job from application client.

I just know it has some issue of granting the access but I have no idea how to grant access to ERM22_TEST_CUSTOM schema which run a package in another schema ERM22_TEST.

ORA-01031: insufficient privileges
ORA-06512: at "ERM22_TEST.ASYNC_JOB_QUEUE_COMMAND_BAS", line 101
ORA-06512: at "ERM22_TEST.ASYNC_JOB_QUEUE_COMMAND_BAS", line 106
ORA-06512: at "ERM22_TEST_CUSTOM.C_PSP_INTERFACE", line 39
ORA-06512: at "ERM22_TEST_CUSTOM.C_PSP_INTERFACE", line 95

分享到QQ

分享到微博