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?"