Change oracle db user password without knowing existing password PHP

Question

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?

Tony Andrews · Accepted Answer · 2017-08-17 09:45:32Z

2

A user with the alter user system privilege can run:

ALTER USER user_name IDENTIFIED BY new_password;

answered Aug 17, 2017 at 9:45

Tony Andrews

133k23 gold badges230 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1451517 Over a year ago

Thank you, would I use this as a query?

Tony Andrews Over a year ago

You could run a PL/SQL block that uses execute immediate i.e.: begin execute immediate 'ALTER USER user_name IDENTIFIED BY new_password; end;' end;

Collectives™ on Stack Overflow

Change oracle db user password without knowing existing password PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related