Syntax highlight error on CREATE USER

Well helllllllloooooo!

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.

Thanks!
Rich

Helllooooooo!

This one is for @avergison. I just wanted to say Helllloooooo. La, La, Laaaa...

1 Like

At least I didn't say "Shmoopie". :smiley:

1 Like

Oh I was missing this post sooo long ... sorry. :slight_smile:

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)

Thanks for your report,
Andre

1 Like