Password Management

How to Resolve ORA-28007: the password cannot be reused

by Ed Chen
January 10, 2023January 6, 2023

ORA-28007 Some user tried to change its own password, but it failed with ORA-28007. SQL> password Changing password for HR Old password: New password: Retype… Read More »

How to Defer Password Expiration

by Ed Chen
January 9, 2023January 8, 2023

To solve ORA-28001 and ORA-28002, the best way is to follow the rule to change user's password. However, if you had to continue using the… Read More »

USER$, How and Why

by Ed Chen
January 6, 2023January 16, 2023

SYS.USER$ is a table which stores all user's password information. Generally, the table should be used only by Oracle internal system and not DBA. If… Read More »

USER_ASTATUS_MAP, How and Why

by Ed Chen
January 5, 2023March 8, 2023

SYS.USER_ASTATUS_MAP provides a list of account status bit and their definitions. Let's see its content. In which, ASTATUS stands for "Account STATUS". SQL> show user… Read More »

DBA_USERS_WITH_DEFPWD, How and Why

by Ed Chen
January 4, 2023February 21, 2023

The data dictionary DBA_USERS_WITH_DEFPWD tells us that the users who are still using their default passwords defined in table DEFAULT_PWD$. For example, we have some… Read More »

DEFAULT_PWD$, How and Why

by Ed Chen
January 3, 2023January 3, 2023

What is Default Password? Default passwords are predefined users who has the default password stored in a table called SYS.DEFAULT_PWD$. In other words, any user… Read More »

How Oracle Alter User Password Expire

by Ed Chen
November 29, 2022March 9, 2023

Expire User Password In this post, we introduce two ways to expire an user's password in N days. The first one provides no grace time,… Read More »

Oracle Change User Password

by Ed Chen
November 28, 2022February 21, 2023

Change User Password Periodically, you may like to change your own password for more protection. In fact, there're many ways that can change user's password… Read More »

How to Resolve ORA-28002: the password will expire within 7 days

by Ed Chen
February 1, 2020January 9, 2023
2 Comments

ORA-28002 ORA-28002 means that the password of the user will expire soon in N days, although the user is allowable to connect to the database.… Read More »

How to Resolve ORA-28001: the password has expired

by Ed Chen
January 4, 2020January 9, 2023
10 Comments

ORA-28001 ORA-28001 means that your password has been expired according to your profile. Normally, you should change the password, but you can still work around… Read More »