- Part 1: ALTER USER RENAME - A half official option
- Part 2: ALTER USER RENAME - Part 2
- Part 3: ALTER USER RENAME - Part 3
Inspired by a Twitter Comment from Franck Pachot and as I love to test really funny and strange things with Oracle Products.
I was trying to rename the SYS user and the SYSTEM user.
SQL> alter session set "_enable_rename_user"=true; SQL> alter system enable restricted session; SQL> alter user sys rename to mysys identified by "Oracle12c"; alter user sys rename to mysys identified by "Oracle12c" * ERROR at line 1: ORA-42289: may not rename specified user
The same applies for the SYSTEM user