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
How Oracle Rename Userby Ed ChenOctober 20, 2022November 17, 2022There'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
How to Resolve ORA-65049: Creation of local user or role is not allowed in this containerby Ed ChenJune 13, 2022June 15, 2022ORA-65049 Tried to create a user in the current container, but it failed with ORA-65049. SQL> create user hr container=current; create user hr container=current *… Read More »How to Resolve ORA-65049: Creation of local user or role is not allowed in this container