Software QA (13)
SQL Server (1)
How To Change User Password
How To Change User Password? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
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".
2007-05-02, 4816👍, 0💬
How Many Types of Tables Supported by Oracle? - Oracle DBA FAQ - Managing Oracle Database Tables Ora...
What Happens If the UPDATE Subquery Returns Multiple Rows? - Oracle DBA FAQ - Understanding SQL DML ...
What is continuous and staged representation? CMMI contains 25 key process areas which organization ...
How can I include comments in HTML? An HTML comment begins with "<!--", ends with "-->...
Explain all parts of a deployment diagram? Package: It logically groups element of a UML model. Node...