Force User to Change Password at First Loginby Ed ChenApril 3, 2023May 31, 2023We 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
USER_ASTATUS_MAP, How and Whyby Ed ChenJanuary 5, 2023November 12, 2023SYS.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
How Oracle Alter User Password Expireby Ed ChenNovember 29, 2022August 28, 2023Expire 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 daysby Ed ChenFebruary 1, 2020January 9, 20232 CommentsORA-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 expiredby Ed ChenJanuary 4, 2020January 9, 202310 CommentsORA-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