Super long-time, no post! Running beta 16.2.77.1712, I have this simple yet fun statement:
CREATE USER JDOE PROFILE P_SUPER_COOL_DBA;
...which in Oracle 19 is valid syntax and executes fine from the Editor, but the syntax highlighter really wants me to identify the user. Super cool DBAs refuse to be identified. And me, too.
Well, in both 19 and 21 documentation the authentication clause seems to be mandatory.
I tested it in 21 and Oracle is fine without. So CREATE USER john works.
I changed parse to accept it, of course. (QP-4070)