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
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
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
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
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
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
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