Home » RDBMS Server » Security » Checking Oracle Users Password
Checking Oracle Users Password [message #21060] Tue, 09 July 2002 22:48 Go to next message
Messages: 38
Registered: March 2001
Hi !,

I want to check Oracle User password or i want to get Oracle User Old password while changing password thru SQL or PL/SQL scripts, how it is possible. Please help me out.

Re: Checking Oracle Users Password [message #21063 is a reply to message #21060] Wed, 10 July 2002 03:04 Go to previous message
Mahesh Rajendran
Messages: 10702
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
SQL> ed
Wrote file afiedt.buf

  1  create or replace procedure test_user
  2  (user in varchar2,
  3   pass in varchar2)
  4  authid current_user
  5  is
  6  str varchar2(100);
  7  begin
  8  str:='alter user '||user||' identified by '||pass;
  9  execute immediate str;
 10* end;
SQL> /

Procedure created.

SQL> exec test_user('mag','mag');

PL/SQL procedure successfully completed.

SQL> connect mag/mag@rdtest;
SQL> exec test_user('mag','newpass');

PL/SQL procedure successfully completed.

SQL> connect mag/newpass@rdtest;
Previous Topic: Help - Password expired with grace period does not raise an error
Next Topic: PL/SQL Random Password Generator
Goto Forum:

Current Time: Fri May 27 13:50:13 CDT 2022