previleges...help

[helpme]

hello ppl,
This would really sound silly...but pls help me

I have ..or rather HAD an oracle d/b server installed on my local machine...

I rally wanted to play around with the database to learn more.
So I tried to change the prev of the SYS user.
Now its changed..now what to do?
Cause I ve lost all the prev
Is there any way to get it back........
I dont want to re install the d/b again
thanx in advance

[helpme]

pls help me....

[rohitsn]

Hi,
SO u want to get back the privileges granted to SYS.Login into Server Manager and then connect as internal (password:Oracle) and then grant all the necessary privileges to SYS user.

svrmgr>connect internal
svrmgr>grant dba to sys;

In case of any help please be free to ask me at rohitsn@altavista.com

Regards,
ROhit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com

[santoshym]

Hi

Experimenting is the best way to learn anything dont worry as long as it is a test system offcourse dont go and experiment on production system.

Invoke server manager as Rohit says and grant whatever privileged Which you have revoked from sys user.That should work fine

Regards