CODEWITHSUNDEEP
sqloracle10g
Anu
Anu

Reputation: 158

How do i create a user without 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.

Upvotes: 2

Views: 7074

Answers (2)

ibre5041
ibre5041

Reputation: 5298

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.

Upvotes: 4

umesh
umesh

Reputation: 11

you can create user without password by using externally keyword OS authentication of that user is used as password,user should have access permission on database .

Upvotes: 1

Related Questions