The following refers to whether the password is expired before Oracle 10g--is checked Select B.username user name, B.profile, b.account_status status, b.created creation date, A.ptime set date, B.lock_date lock date, b.expiry_date password expiration time From (SELECT * from sys.user$) A, (SELECT * from dba_users) b where a.name = B.username and account_status= ' OPEN '
--Check the system parameters before executing select profile, Resource_name, LIMIT from Dba_profiles where resource_name in (' Password_life_time ', ' Password_grace_time ', ' Password_reuse_max ', ' Password_loc K_time ', ' failed_login_attempts ', ' password_verify_function ') Order by 1
First modified to unrestricted alter profile default limit Password_reuse_max Unlimited;alter profile default limit password_reuse_time Unlimite D
--alter User sys identified by JMPSBXXB
alter user system identified by JMPSBXXBAlter profile DEFAULT Limit Password_reuse_max Unlimited;alter profile DEFAULT Limit Password_reuse_time UNLIMITED;
--Execute the following script to generate the modification script,
Select ' Alter user ' | | Username | | ' identified by values ' | | password | | '; ' from dba_users
where account_status<> ' LOCKED ' and account_status don't like ' expired%locked ';
--then execute the script generated above,
--alter user Sup_flex identified by values ' 96679a1e6c027eaf ';
--and then changed to a limitedalter profile DEFAULT limit Password_reuse_time 5;Alter profile DEFAULT limit Password_reuse_max 5;
Oracle 11g
Select Name,password from sys.user$, where name in (select username from dba_users);in fact, Dba_users is a view created with related base tables such as user$.
from the dba_uses view, you can see that when a user is created as a global or external authentication, password has an encrypted value, while the password column of dba_users in 10g fully values the user$ column value of password
From for notes (Wiz)
Periodically change password periodically refresh password-copy