Hi,
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
Connected.
SQL> shutdown immediate;
ORA-01031: insufficient privileges
SQL> connect anurag/anurag@orcl8i as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
Thanks
Anurag
[Edited by anuragmin on 06-12-2001 at 10:19 AM]