I created a user anurag and assigned him dba, resource and connect roles.

Now I want to be able to shutdown the database using this user but am unable to login as sysdba.
what steps do I need to take so that I should be able to connect as sysdba.

Infact I am unable to shutdown the database using internal also from the sql plus prompt but am able to do so using internal from the enterprise manager.

SQL> connect anurag/anurag@orcl8i
SQL> shutdown immediate;
ORA-01031: insufficient privileges
SQL> connect anurag/anurag@orcl8i as sysdba
ORA-01031: insufficient privileges

Warning: You are no longer connected to ORACLE.


[Edited by anuragmin on 06-12-2001 at 10:19 AM]