How do I Reset My Password or Create New User in Oracle

       

          We people are using the Password in various scenarios. A feature of passwords is the ability to change or reset it. The need to change a password come about for 2 reasons: 

1. Maintaining high security by regularly changing the password.

2. The authorized user to regain access to it when the password is either    
     forgotten or lost.

Common Password Changing Process

             Every service or product which  has an option for changing the password. This option is majorly found in the “Administrative Panel” or the “User Management Panel”. Most of the password changing components follows a common pattern as depicted below.

Enter Old Password
Enter New Password
Confirm New Password

Lost Password Recovery

           When it comes to users forgetting their passwords, service providers offer them a way to regain access to their accounts by resetting their passwords for them.

Steps to Reset Password or Create New User in Oracle :

  

1. To reset password in Oracle, you just open command prompt Using  

     typing "cmd" command in Run Window.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>

2. Then  Type "sqlplus /nolog" in Command Prompt.

C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Sat Nov 27 00:30:06 2010
(c) Copyright 2000 Oracle Corporation.  All rights reserved.
SQL>

3.To Connect to Admin, type "conn / as sysdba" in Command Prompt.

SQL> conn / as sysdba
Connected.

4. To Show the Description of Users in Oracle DataBase, type "desc dba_users;"

SQL> desc dba_users;

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 USERNAME                                  NOT NULL VARCHAR2(30)
 USER_ID                                   NOT NULL NUMBER
 PASSWORD                                           VARCHAR2(30)
 ACCOUNT_STATUS                            NOT NULL VARCHAR2(32)
 LOCK_DATE                                          DATE
 EXPIRY_DATE                                        DATE
 DEFAULT_TABLESPACE                        NOT NULL VARCHAR2(30)
 TEMPORARY_TABLESPACE                      NOT NULL VARCHAR2(30)
 CREATED                                   NOT NULL DATE
 PROFILE                                   NOT NULL VARCHAR2(30)
 INITIAL_RSRC_CONSUMER_GROUP                        VARCHAR2(30)
 EXTERNAL_NAME                                      VARCHAR2(4000)

5.Select the UserName from Users, type "select username from dba_users;"

SQL> select username from dba_users;

USERNAME
------------------------------
SYS
SYSTEM
OUTLN
DBSNMP
AURORA$JIS$UTILITY$
OSE$HTTP$ADMIN
AURORA$ORB$UNAUTHENTICATED
ORDSYS
ORDPLUGINS
MDSYS
CTXSYS

USERNAME
------------------------------
SCOTT

SENTHIL
ADAMS
JONES
CLARK
BLAKE
MTSSYS

6.To Connect the Particular User, type "conn username/password

SQL> conn senthil/senthil

Note : 

        if u don't have such user or frgot the password, it will show the error message likewise..

 

ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.

SQL> conn scott/tiger

connected.

7. To Show the Current User

SQL> show user
USER is "scott"

8. To Reset the Password, type as "alter user username identified by password;"

SQL> alter user senthil identified by mypwd;

User altered.

9. After Connect Scott User using new Passwor, type as "conn username/password"

SQL> conn senthil/mypwd

Connected.

10. To Create a New User, type as "create user NewUserName identified by NewPassword;"

SQL> create user kumar identified by mypwd;
User created.

11. To Grant Permisson to use all the features, type as "grant connect,resource to NewUserName;

SQL> grant connect,resource to kumar;
Grant succeeded.

Keep Learn New Things!

All is Well!

"I had a sickening feeling every time I thought about it. I still do." -- George W. Bush