Oracle apex 问题 - ORA 20987：APEX - 用户没有需要 ADMIN 权限来执行此操作。- 联系您的应用程序管理员
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/34992225/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle apex issue - ORA 20987: APEX - User nobody requires ADMIN privilege to perform this operation. - Contact your application administrator
提问by Thusira Dissanayake
I recently migrate my application from APEX 4.2 to 5.0. And now when i try to log in, error message shows up like this.
我最近将我的应用程序从 APEX 4.2 迁移到 5.0。现在当我尝试登录时，错误消息显示如下。
ORA-20987: APEX - User nobody requires ADMIN privilege to perform this operation. - Contact your application administrator.
ORA-20987：APEX - 用户 nobody 需要 ADMIN 权限才能执行此操作。- 联系您的应用程序管理员。
it happens when preforming the login. even login with the blank credentials. after login pressed it checks for the following,
它发生在执行登录时。甚至使用空白凭据登录。登录后按下它检查以下内容，
DECLARE l_err_mesg VARCHAR2(500);
BEGIN
IF APEX_UTIL.GET_ACCOUNT_LOCKED_STATUS(p_user_name => :P101_USERNAME ) then
l_err_mesg := '<span style="color: red"> Account currently locked. </span>';
END IF;
RETURN l_err_mesg;
EXCEPTION WHEN OTHERS THEN
raise_application_error(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
END;
Please tell me what am I missing with this.
请告诉我我错过了什么。
回答by Typo
With Oracle Application Express 5.0, employing APEX_UTIL to manage workspace users and groups requires specific configuration. The default settings in APEX5 will provide give you an error when you employ APEX_UTIL for workspace users and groups
对于 Oracle Application Express 5.0，使用 APEX_UTIL 来管理工作区用户和组需要特定的配置。当您为工作区用户和组使用 APEX_UTIL 时，APEX5 中的默认设置会给您一个错误
If you write and test code in SQL-Developer or SQLPlus, you will not likely encounter this error until you paste your code into APEX. The change is simple:
如果您在 SQL-Developer 或 SQLPlus 中编写和测试代码，则在将代码粘贴到 APEX 之前，您不太可能遇到此错误。改变很简单：
Go to: Edit Application Properties > Security > Runtime API Usage
转到：编辑应用程序属性 > 安全性 > 运行时 API 使用
You'll find this as the very last item below database session. Add a check mark to permit “Modify Workspace Repository” as shown in the image below.
您会发现这是数据库会话下面的最后一项。添加复选标记以允许“修改工作区存储库”，如下图所示。
Saving this change to your Application Properties will clear the error.
将此更改保存到您的应用程序属性将清除错误。
