previleges...help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: previleges...help

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    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

  2. #2
    Join Date
    Jun 2001
    Posts
    316
    pls help me....

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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

  4. #4
    Join Date
    Mar 2001
    Posts
    635
    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
    Santosh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width