How to Unexpire Password
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 »How to Unexpire Password
ASTATUS
USER$, How and Why
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$, How and Why
USER_ASTATUS_MAP, How and Why
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 »USER_ASTATUS_MAP, How and Why
DBA_USERS_WITH_DEFPWD, How and Why
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 »DBA_USERS_WITH_DEFPWD, How and Why
How Oracle Alter User Password Expire
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 »How Oracle Alter User Password Expire
How to Resolve ORA-28002: the password will expire within 7 days
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-28002: the password will expire within 7 days
How to Resolve ORA-28001: the password has expired
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 »How to Resolve ORA-28001: the password has expired
How to Resolve ORA-28000: The account is locked
ORA-28000 ORA-28000 means that the account that you tried to use is locked because some privileged user disabled the ability of connection, or attempt connections… Read More »How to Resolve ORA-28000: The account is locked