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>
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.
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;"
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
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
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.
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"
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.
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.
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