changing password with oracle's SQL Developer

Question

Many of my users do not use sqlplus. I cannot give them alter user. We expire passwords every 60 days.

I can't get the sqlplus command "password" to work in sql developer.

1. When I hit run, I get an invalid command error
2. When I hit run script, nothing happens.

I don't want to write them a package to change their passwords since we have alot of databases. Do I have a better option?

Answer 1

Your users can still change their passwords by "alter user onlyTheirUserName identified by newpassword". They do not have to have the ALTER USER privilege to change their own password.