ALTER USER Statement - Oracle to MySQL Migration

In Oracle and MySQL, the ALTER USER statement modifies an existing user, but some clauses can differ and require conversion.

Both Oracle and MySQL allow you to enable all roles granted to a user at logon.

Oracle:

  ALTER USER "USER1" DEFAULT ROLE ALL;
  /* User altered. */

MySQL:

  ALTER USER "USER1" DEFAULT ROLE ALL;
  /* Query OK, 0 rows affected */

For more information, see Oracle to MySQL Migration.