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
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>grant dba to sys;
In case of any help please be free to ask me at firstname.lastname@example.org
ROhit Nirkhe,Oracle DBA,OCP 8i
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
Click Here to Expand Forum to Full Width