HI GURU'S,

grant sysdba to saurabh;
sqlplus "saurabh/saurabh as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Dec 24 19:42:26 2002

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL>exit

sqlplus "/ as sysdba"

SQL> revoke sysdba from saurabh;

Revoke succeeded.

sqlplus "saurabh/saurabh as sysdba"

--IT AGAIN CONNECT -- WHY --
I DELETED MY PASSWORD FILE AND RECREATED THE FILE.
orapwd file=C:\oracle\ora92\database\PWDtest.ora password=saurabh2 entries=2

SO KNOW ONLY SYS CAN ACCESS THIS DATABASE AS SYSDBA
BUT
WHEN I AGAIN LOGGED IN WITH SAURABH


sqlplus "saurabh/saurabh as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Dec 24 19:42:26 2002

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL>exit




---------------------------------
I CANT UNDERSTAND WHY THIS IS HAPPENING AND HOW CAN I RESOLVE IT.


DATABASE VERSION IS 9.2.0.1 RELEASE 2