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, 1711🔥, 0💬
Popular Posts:
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...