- 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
