CREATE USER Statement - Oracle to MariaDB Migration

In Oracle and MySQL, the CREATE USER statement creates a new user, but some clauses differ and require conversion.

Oracle:

  -- Create a sample user
  CREATE USER "USER1" IDENTIFIED BY VALUES 'S:E4406C13C44...;H:6AE38B92223...;T:B99DEE30A...'
      DEFAULT TABLESPACE "TBS_DATA"
      TEMPORARY TABLESPACE "TEMP"
      PROFILE "USER_PROFILE"
      PASSWORD EXPIRE;

MariaDB:

  -- Create a sample user
  CREATE USER "USER1" IDENTIFIED BY '<password>'
     PASSWORD EXPIRE;

Note that you cannot reuse the hash value specified in the IDENTIFIED BY VALUES clause in Oracle when converting to MariaDB. You have to replace it with a password or another hash value appropriate for a MariaDB authentication plugin.

For more information, see Oracle to MariaDB Migration.