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, 2217🔥, 0💬
Popular Posts:
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...