Oracle - Change User Password in Oracle

Change User Password in Oracle

Q

How To Change User Password in Oracle?

✍: FYIcenter.com

A

If you want to change a user's password, you can log in as SYSTEM and use the ALTER USER command as shown in the following example:

>.\bin\sqlplus /nolog

SQL> connect SYSTEM/fyicenter
Connected.

SQL> ALTER USER DEV IDENTIFIED BY beginner;
User altered.

Note that ALTER is SQL statement, so you need to terminate it with ";". This command resets DEV's password to "beginner".

⇒Managing Oracle User Accounts, Schema and Privileges

⇒⇒Oracle Database Tutorials

2019-07-09, 734👍, 0💬

Create a New User Account in Oracle
How To Create a New User Account in Oracle? If you want to create a new user account, you can log in as SYSTEM and use the CREATE USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL> CREATE USER DEV IDENTIFIED BY dev... 2019-07-21, 738👍, 0💬

Show All User Accounts in Oracle
How To List All User Accounts in Oracle? User accounts can be accessed through a system view called ALL_USERS. A simple SELECT statement can be used to get a list of all user accounts. Try the following script: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL> ... 2019-07-21, 738👍, 0💬

Change User Password in Oracle
How To Change User Password in Oracle? If you want to change a user's password, you can log in as SYSTEM and use the ALTER USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL> ALTER USER DEV IDENTIFIED BY beginner; U... 2019-07-09, 735👍, 0💬

Delete a User Account in Oracle
How To Delete a User Account in Oracle? If you want to delete a user account and its associated schema, you can log in as SYSTEM and use the DROP USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL> DROP USER DEV CAS... 2019-07-09, 661👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.