tag:blogger.com,1999:blog-21122514.post6889045737667644456..comments2024-03-23T11:05:13.046+01:00Comments on Dimitri Gielis Blog (Oracle Application Express - APEX): Reset INTERNAL password in APEX 3.0Dimitri Gielishttp://www.blogger.com/profile/16295721159626839167noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-21122514.post-55203383573446732912009-10-13T14:29:31.089+02:002009-10-13T14:29:31.089+02:00In the Adminstration you can set the "Require...In the Adminstration you can set the "Require Change of Password on First Use" to No<br /><br />You can find this in Manage Workspaces -> Manage Developers and Users -> Create / Edit Users<br /><br />I encountered the same problem first and it is annoyingLuiindezonhttps://www.blogger.com/profile/02474577784727796769noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-75137521031330265442009-08-03T08:59:36.878+02:002009-08-03T08:59:36.878+02:00If you are in APEX 3.2, have a look here: http://d...If you are in APEX 3.2, have a look here: http://download.oracle.com/docs/cd/E14373_01/install.32/e13366/db_install.htm#CIHBHAFJ<br />You can use @apxchpwd.sqlDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-63299592080276352042007-10-16T21:58:00.000+02:002007-10-16T21:58:00.000+02:00After I follow the directions to add a new interna...After I follow the directions to add a new internal workspace admin it asks me to change the password right away. When I put in the current password it tells me invalid password. Any advise?Unknownhttps://www.blogger.com/profile/00590056970751046956noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-1375959096089616692007-10-09T18:25:00.000+02:002007-10-09T18:25:00.000+02:00There is a typo in the package names above. The co...There is a typo in the package names above. The correct script is:<BR/><BR/>begin<BR/>wwv_flow_api.set_security_group_id (p_security_group_id => 10);<BR/>wwv_flow_fnd_user_api.create_fnd_user(<BR/>p_user_name => 'admin1',<BR/>p_email_address => 'gellert.stadler@generali.hu',<BR/>p_web_password => 'admin1');<BR/>end;Stadler Gellérthttps://www.blogger.com/profile/01798546622721246241noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-43888395629644593122007-10-03T21:32:00.000+02:002007-10-03T21:32:00.000+02:00Doesn't work :(SQL> alter user FLOWS_030000 accoun...Doesn't work :(<BR/><BR/><BR/><BR/>SQL> alter user FLOWS_030000 account unlock;<BR/><BR/>User altered.<BR/><BR/>Elapsed: 00:00:00.00<BR/>SQL><BR/>SQL><BR/>SQL> conn flows_030000/oracle<BR/>Connected.<BR/>SQL><BR/>SQL> begin<BR/> 2 www.flow_api.set_security_group_id (p_security_group_id => 10);<BR/> 3 www.flow_fnd_user_api.create_fnd_user(<BR/> 4 p_user_name => 'admin1',<BR/> 5 p_email_address => 'email@ae.com',<BR/> 6 p_web_password => 'admin1');<BR/> 7 end;<BR/> 8 /<BR/>www.flow_api.set_security_group_id (p_security_group_id => 10);<BR/>*<BR/>ERROR at line 2:<BR/>ORA-06550: line 2, column 1:<BR/>PLS-00201: identifier 'WWW.FLOW_API' must be declared<BR/>ORA-06550: line 2, column 1:<BR/>PL/SQL: Statement ignored<BR/>ORA-06550: line 3, column 1:<BR/>PLS-00201: identifier 'WWW.FLOW_FND_USER_API' must be declared<BR/>ORA-06550: line 3, column 1:<BR/>PL/SQL: Statement ignoredAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-56929334087550946592007-08-02T00:02:00.000+02:002007-08-02T00:02:00.000+02:00If you've still problems: Easiest thing to do next...If you've still problems: <BR/>Easiest thing to do next would be to connect as flows_030000 in SQL*Plus and:<BR/>update wwv_flow_fnd_user set account_locked = 'N' where security_group_id=10<BR/>/<BR/>commit<BR/>/<BR/>This will unlock any locked accounts in the internal workspace, leaving their passwords as they are.Dimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-26032089493061911562007-04-07T20:35:00.000+02:002007-04-07T20:35:00.000+02:00oh nice, thanks for that Jornicaoh nice, thanks for that JornicaDimitri Gielishttps://www.blogger.com/profile/16295721159626839167noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-15630754238884687972007-04-06T22:04:00.000+02:002007-04-06T22:04:00.000+02:00One of the APEX 3.0 scripts is apxxepwd.sql which ...One of the APEX 3.0 scripts is apxxepwd.sql which edits the ADMIN user instead of creating a new user ADMIN1. Connect as SYS (as SYSDBA) and execute the script. It will ask for the new password. <BR/><BR/>The name of the script (apxXEpwd) suggests it has something to do with XE. The comments inside the script do not refer to XE...Jornicahttps://www.blogger.com/profile/15492511382521784329noreply@blogger.com