PASSWORD RESET

create user Moid identified by abc123 password expire;

2

SQL>alter user scott identified by india123;

3How to check last password change date in Oracle?

set linesize 200

set pagesize 200

col Last_Password_Change_Time format a30

select

     user#,

     name,

     ctime as Creation_Time,

     --to_char(ctime,'DD-MON-YY HH:MI') as Creation_Time,

     to_char(ptime,'DD-MON-YY HH:MI') as Last_Password_Change_Time

from

     SYS.USER$

where

     ctime is not null

     and

     name not in (select role from dba_roles)

order by ptime;

4

to unlock

alter user username account lock;

5

alter user username identified by new_password;

. oraenv 

PrimeDG

echo $ORACLE_SID

sqlplus / as sysdba

SQL>show user;

SQL>select name from v$database;

SQL>select username from dba_users where username='Amin';

SQL>select account_status from dba_users where username='Amin';

SQL>alter user Amin identified by india123 password expire;

or 

SQL>alter user scott identified by india123;