The very useful function of creating DDL-scripts by dragging a component to a sql-window has an error in creating a user:
Now it gives:
"create user INFEKTION
identified by "5EB876213443901A"
default tablespace users
temporary tablespace TEMP
profile DEFAULT"
setting the password to "5EB876213443901A" i.e the encrypted version of the password!
In order to revreate the original password as seen by the user the DDL should be:
"create user INFEKTION
identified by values '5EB876213443901A'
default tablespace users
temporary tablespace TEMP
profile DEFAULT"
Now it gives:
"create user INFEKTION
identified by "5EB876213443901A"
default tablespace users
temporary tablespace TEMP
profile DEFAULT"
setting the password to "5EB876213443901A" i.e the encrypted version of the password!
In order to revreate the original password as seen by the user the DDL should be:
"create user INFEKTION
identified by values '5EB876213443901A'
default tablespace users
temporary tablespace TEMP
profile DEFAULT"
