ALTER USER RENAME - Part 3
Posted by Dirk Nachbar on Thursday, March 24, 2016
This is part 3 of the ALTER USER RENAME series
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.
The same applies for the SYSTEM user
- 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
Categories: Oracle
