How to Resolve ORA-01918: user does not exist
ORA-01918 Tried to change an user's attribute, but it failed with ORA-01918. SQL> alter user ht account unlock; alter user ht account unlock … Read More »How to Resolve ORA-01918: user does not exist
DBA_USERS_WITH_DEFPWD
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_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