Changing password with Oracle SQL Developer

Question

Many of my users aren't using the SQLPlus. I can't give them alter user. We expire the passwords for every 60 days.

I can't get the SQLPlus command "password" to work in the SQL developer.

1. When I am running, I get an invalid command error
2. When I click run script, nothing is happening.

I don't need to write them a package to change their passwords since we are having a lot of databases. Do I have any other better option?

Answer 1

The right syntax for updating the password using the SQL Developer is:

alter user user_name identified by new_password replace old_password ;

Join the SQL Course by Intellipaat now if you want to learn SQL in detail and get certified.

Watch this below video tutorial on how to become a professional in SQL.