Home » RDBMS Server » Security » Change Oracle Password
Change Oracle Password [message #38485] Mon, 22 April 2002 09:25 Go to next message
Chris
Messages: 128
Registered: November 1998
Senior Member
Hi,
This is a piece of code that I use for updating the Oracle password using Oracle Forms.

"......
ID := :PASSWD.User_Name;
NewPW := :PASSWD.New_PW;

Command := 'plus80w '||id||'/'||CurPW||'@'||dest||' @changepw '||id ||' '||newpw ;
HOST(Command,NO_SCREEN);

IF FORM_SUCCESS THEN
Message('Request Processed.');
ELSE
Message(TO_CHAR(Message_Code) || ':' || MsgTxt;
RAISE Form_Trigger_Failure;
END IF;
..."

It works fine except for some cases like the password has been used previously, there is no way for me to identify the problem or recieve the error message. FORM_SUCCESS is still set to TRUE because nothing wrong with Command.

Can someone help me with this?

Thanks in advance.
Chris
Re: Change Oracle Password [message #38518 is a reply to message #38485] Wed, 24 April 2002 11:37 Go to previous message
oraboy
Messages: 97
Registered: October 2001
Member
why not use..FORMS_DDL from your forms itself

FORMS_DDL('alter user '||:username||' identified by '||:newpasswd);

simple and handy,right?

oraboy
Previous Topic: encrypt/decrypt password field in a user defined table for oracle 8i release 8.1.5
Next Topic: Install 9i Startup Password?
Goto Forum:
  


Current Time: Thu Mar 28 05:54:06 CDT 2024