Generated user script fails syntax check

Toad for Oracle - Beta
1

Scripted an existing user. Cut/pasted the CREATE USER statement into an editor window and it fails syntax check. This is true in both 17.0 and 17.1.451.2700 beta.

CREATE USER EFUDD
  IDENTIFIED BY VALUES 'S:D86648D5546AFD1E275E2E57072D416A668ED0BC950E4F0E288AFC84418F;T:4B8A88CD953F4801EC6D4930FC4037C30F3FFFF299602F94907F577D4745109230167AE24DD033CC8072CCB793EBC03F744BC4E559C7259891ECA4376680D892199A12DFAB7BBEDCF8D17DBED00C89AD'
  HTTP DIGEST DISABLE
  DEFAULT TABLESPACE USERS
  TEMPORARY TABLESPACE TEMP
  PROFILE END_USER
  ACCOUNT UNLOCK;

image
image1103×132 8.55 KB

BTW, the statement executes successfully.

2

It has been 2 weeks. Has this post slipped through the cracks?

3

Well you chose two rather critical weeks :slightly_smiling_face: .

The thing is that Oracle never documented (AFAIK) the HTTP DIGEST clause working together with the equally undocumented IDENTIFIED BY VALUES clause.

I fixed it to show up in component QP5.DLL version 5.405 (and later). May last one or two more weeks...

Thanks for reporting,
Andre