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>