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 Defer Password Expiration
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
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 Expire User Password
There's no direct way to rename an user, simply because Oracle does not support it. A supported way is to DROP USER then CREATE USER… Read More »How Oracle Rename User