Version 8.0.0.1480.
Dragging a username to q sql-window to produce ddl, gives the wrong syntax:
create user TEST1
identified by FF8628E1A1FDEA93
...
Setting password to the encrypted version of the password.
The correct syntax is:
create user TEST1
identified by values 'FF8628E1A1FDEA93'
...
which stores the given value in the database as the encrypted password.
The allowes logon with the original password, without revealing it.
Dragging a username to q sql-window to produce ddl, gives the wrong syntax:
create user TEST1
identified by FF8628E1A1FDEA93
...
Setting password to the encrypted version of the password.
The correct syntax is:
create user TEST1
identified by values 'FF8628E1A1FDEA93'
...
which stores the given value in the database as the encrypted password.
The allowes logon with the original password, without revealing it.
