How to change user password in oracle?



How to change user password in oracle?..

Answer / Gopal Krishna

To change a user's password in Oracle, use the `ALTER USER` command. Here's an example:

```sql
ALTER USER existing_user IDENTIFIED BY new_password;
```
Replace `existing_user` with the name of the user you want to change the password for and `new_password` with the desired new password.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

query optmization techniques and quwry analyser+projects+ppts

1 Answers  


How can you use check constraints for self referential integrity?

1 Answers  


ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?

4 Answers  


what is the scenario where you take the database to NoArchivelog mode?

1 Answers  


How to define a variable of a specific record type?

1 Answers  


How to start a specific oracle instance?

1 Answers  


What is a snapshot log?

1 Answers  


How to handle a single quote in oracle sql?

1 Answers  


What is a connect identifier?

1 Answers  


How can you merge two tables in oracle?

1 Answers  


How to change program global area (pga) in oracle?

1 Answers  


Can you have more than one content canvas view attached with a window ?

1 Answers   Oracle,


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)