oracle 解锁 Apex 管理员帐户
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/50338447/
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
Unlock apex admin account
提问by Phanny
I run @apxchpwd.sql and unluck the account with this script
我运行@apxchpwd.sql 并使用此脚本取消帐户
alter session set current_schema = APEX_050100;
declare
l_workspace_id number := apex_util.find_security_group_id (p_workspace => 'INTERNAL');
begin
wwv_flow_security.g_security_group_id := 10;
apex_util.set_security_group_id (p_security_group_id => l_workspace_id);
wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('ADMIN');
commit;
end;
But it doest work. Thanks for any help
但它不起作用。谢谢你的帮助
回答by Littlefoot
The apxchpwd.sqlscript is used to change the password, but it also unlocksthe ADMIN account (, so - you shouldn't even need any additional code. Just make sure to run the one that belongs to Apex version you use.
该apxchpwd.sql脚本用于更改密码，但它也会解锁ADMIN 帐户（因此 - 您甚至不需要任何其他代码。只需确保运行属于您使用的 Apex 版本的代码即可。
SQLPLUS /NOLOG
SQL> CONNECT SYS AS SYSDBA
SQL> @APXCHPWD
Alternatively, also connected as SYS, use the following code:
或者，也以 SYS 身份连接，使用以下代码：
BEGIN
apex_util.set_security_group_id(p_security_group_id => 10);
apex_util.unlock_account(p_user_name => 'ADMIN');
END;
/
COMMIT;
回答by Anas sanjalawi
Follow these step to Unlock Users After execute @apxchpwd.sql in oracle apex - log in as Administration - Manage WorkSpaces - Manage Developers and Users - chose users that you have to unlock - account avilability ---> Unlock
在 oracle apex 中执行@apxchpwd.sql 后，按照以下步骤解锁用户 - 以管理身份登录 - 管理工作区 - 管理开发人员和用户 - 选择您必须解锁的用户 - 帐户可用性 ---> 解锁
回答by Osama Al-Banna
Here is another solution that worked for me if the above didn't work for you : credit to : https://ora01948.wordpress.com/2017/12/19/unlock-apex-admin-account/
如果上述方法对您不起作用，这是另一种对我有用的解决方案：归功于：https: //ora01948.wordpress.com/2017/12/19/unlock-apex-admin-account/
run the below script noting that OracleAPEXschema name can be different in my case it'sApex_050000so check your schema name first and change it accordingly.
运行以下脚本，注意 OracleAPEX架构名称在我的情况下可能不同，Apex_050000因此请先检查您的架构名称并相应地更改它。
`UPDATE Apex_050000.Wwv_Flow_Fnd_User
SET Web_Password = 'set_new_password'
WHERE User_Name = 'ADMIN'
AND Security_Group_Id = 10;
COMMIT;`
now change the session
现在更改会话
ALTER SESSION SET CURRENT_SCHEMA = Apex_050000;
ALTER SESSION SET CURRENT_SCHEMA = Apex_050000;
and run the below script to unlock the account .
BEGIN
Wwv_Flow_Security.G_Security_Group_Id := 10;
Wwv_Flow_Fnd_User_Api.Unlock_Account ('ADMIN');
COMMIT;
END;
并运行以下脚本来解锁帐户。
BEGIN
Wwv_Flow_Security.G_Security_Group_Id := 10;
Wwv_Flow_Fnd_User_Api.Unlock_Account ('ADMIN');
COMMIT;
END;
