0 votes
1 view
in SQL by (6.1k points)

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?

1 Answer

0 votes
by (12.7k points)

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.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jul 17, 2020 in SQL by Sudhir_1997 (55.5k points)
0 votes
1 answer
asked Jul 17, 2020 in SQL by Sudhir_1997 (55.5k points)
0 votes
1 answer
asked Jul 17, 2020 in SQL by Sudhir_1997 (55.5k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !

Categories

...