Help Creating a user with DBA priviledges...

[dguywill]

Hello All,
I am having a very difficult time shutting down my database instance with the USER accounts I have. I will like to create a user and give it the DBA (exculsive) priviledges. I am using ORACLE 8 on a NT platform. I could not even shutdown the database using the sys/change_on_install, system/manager accounts. Any advice will be very helpful.

Also, I am having problems with the sysdba/sysops option while logging into Enterprise Manager. How do I create a user to have those priviledges..

Thanks,
Dee.

[nbiketi]

Create a password file using orapwd and allow a sufficient number of priviledged users

Modify your parameter file entry REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE

As user sys grant SYSDBA to priviledged users

That should work