revoke role sysdba does not affect

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

its working on myside ??

regards
Amar

--------------------------------------------------------------
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL>
SQL> sho user
USER is "SYS"
SQL>
SQL>
SQL>
SQL>
SQL> create user revoke_test identified by manager
2 default tablespace users;

User created.

SQL> grant connect,resource,sysdba to revoke_test;

Grant succeeded.

SQL> conn revoke_test as sysdba
Enter password:
Connected.
SQL>
SQL>
SQL> connect sys as sysdba
Enter password:
Connected.
SQL> revoke sysdba from revoke_test;

Revoke succeeded.

SQL> conn revoke_test as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges


Warning: You are no longer connected to ORACLE.
SQl>

Quote:

---

Originally posted by saurabhg29

I CANT UNDERSTAND WHY THIS IS HAPPENING AND HOW CAN I RESOLVE IT.
DATABASE VERSION IS 9.2.0.1 RELEASE 2 [/B]

---

Its because your sqlnet.ora setting. Comment SQLNET.AUTHENTICATION_SERVICES= (NTS) prameter from sqlnet.ora and then it will work.. When set to NTS, it uses windows native authentication and thus even though you revoke sysdba privilege it works.

Sameer

thanks