Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Change User Password
How To Change User Password? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
✍: 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".
2007-05-02, 4918👍, 0💬
Popular Posts:
How do we generate strong names ? or What is use the of SN.EXE ? or How do we apply strong names to ...
How To Set session.gc_maxlifetime Properly? - PHP Script Tips - Understanding and Using Sessions As ...
What is the quickest sorting method to use? The answer depends on what you mean by quickest. For mos...
How to create arrays in JavaScript? We can declare an array like this var scripts = new Array(); We ...
Can one execute dynamic SQL from Forms? Yes, use the FORMS_DDL built-in or call the DBMS_SQL databas...