FAILED_LOGIN_ATTEMPTS, How and Why
Unlimited failed logon attempts is certainly convenient for developers and users to access the database, but it leaves a chance for brute force attack to… Read More »FAILED_LOGIN_ATTEMPTS, How and Why
Password Management
Force User to Change Password at First Login
We take the following steps to make a new user change his password at the first time logon to the database. Create User We set… Read More »Force User to Change Password at First Login
How to Resolve ORA-28007: the password cannot be reused
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 Resolve ORA-28007: the password cannot be reused
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
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
DEFAULT_PWD$, How and Why
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 »DEFAULT_PWD$, 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
Oracle Change User Password
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 »Oracle Change User Password