CODEWITHSUNDEEP
phporacle-databaseresetforgot-password
user1451517
user1451517

Reputation: 43

Change oracle db user password without knowing existing password PHP

I have a request to supply the functionality for users to change their Oracle password through their web interface. In the case of an expired password it's fine, but I haven't been able to find a solution if the user has forgotten their password. I've had a look at oci_password_change but the old password is required.

Would there be a way to create an 'admin' db connection and use that to reset the Oracle password for a specific user without knowing the previous password?

Upvotes: 1

Views: 8333

Answers (1)

Tony Andrews
Tony Andrews

Reputation: 132580

A user with the alter user system privilege can run:

ALTER USER user_name IDENTIFIED BY new_password;

Upvotes: 2

Related Questions