How can I create a user without a password in Oracle 10g?


I am trying to create a user without any password by using queries-

create user abc;
create user 'abc'@'localhost';

but neither of them works. It is given on oracle docs that it is valid to create user with no password by including no IDENTIFIED BY clause.

Please help me with this query.

Either use:

  • Oracle wallet. User is identified via password, but the password is not prompted manually.
  • External authentication. CREATE USER XY IDENTIFIED EXTERNALLY; The user XY must then have OS account on the DB server.