Home » Developer & Programmer » Application Express & MOD_PLSQL » apex (password activation)
apex [message #598344] Mon, 14 October 2013 02:58 Go to next message
ariffcal
Messages: 87
Registered: April 2011
Member
After greetings !!!

In Application express I type user as SYSTEM

and password as detasad , however it is saying that the password has expired .

How do I get the password activated .

If I connect as system and password detasad then it says the password will expire in 7 days .

I have forgotten the admin password , can I retrieve it .

Thanks

Report message to a moderator

Re: apex [message #598350 is a reply to message #598344] Mon, 14 October 2013 03:57 Go to previous messageGo to next message
Michel Cadot
Messages: 56533
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You cannot retrieve a password but you can change it connecting you as another DBA account or as SYS.

Report message to a moderator

Re: apex [message #598355 is a reply to message #598344] Mon, 14 October 2013 04:59 Go to previous messageGo to next message
ariffcal
Messages: 87
Registered: April 2011
Member
Please let me know the procedure to change the password , this password is giving a message that it has expired .

Report message to a moderator

Re: apex [message #598356 is a reply to message #598355] Mon, 14 October 2013 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 56533
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Connect with a DBA or SYS account and execute an ALTER USER command.

Report message to a moderator

Re: apex [message #598365 is a reply to message #598344] Mon, 14 October 2013 06:15 Go to previous message
Lalit Kumar B
Messages: 1189
Registered: May 2013
Location: Hi-tech city, Hyderabad
Senior Member
ariffcal wrote on Mon, 14 October 2013 13:28

How do I get the password activated .


As Michel suggested, you cannot recover the password.

Follow these steps -

SQL> connect / as sysdba;

SQL> alter user <username> identified by <password>;


Regards,
Lalit

Report message to a moderator

Previous Topic: Date picker
Next Topic: Apex Jquery
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 09 11:34:59 CST 2013

Total time taken to generate the page: 0.09379 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.