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