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, 1707🔥, 0💬
Popular Posts:
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...