Collections:
Change User Password in Oracle
How To Change User Password in Oracle?
✍: FYIcenter.com
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".
⇒ Delete a User Account in Oracle
⇐ Create a New User Account in Oracle
2019-07-09, 1698🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...