Skip to content Skip to sidebar Skip to footer

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 i

Solution 1:

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.

Solution 2:

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 .


Post a Comment for "How Do I Create A User Without Password In Oracle 10g?"