Re: Forgot password for user "sys"

In article <9402171321.AA29019_at_cs.utexas.edu>, sinues_at_prcd.prc.mrms.navy.mil (John Sinues) writes:
|> What do you do if you lost/forgot the password for the Oracle user "sys"?
|> I do not have the password for this user and am unable to perform any
|> system administrative type functions. Is there a way around this? Is there
|> a way to get the password back or reset it?
|>

You didn't say what platform you're running on. If it's a Unix version of Oracle and you're in the DBA group, you can run sqldba and then "connect internal". This makes you "sys" in the database. Sqldba allows you to issue sql commands so you can then "grant connect to sys identified by xxxx".

|> --
|> ============================================================================
|> _/_/_/_/ _/_/_/_/ _/_/_/_/ John C. Sinues
|> _/ _/ _/ _/ _/
|> _/ _/ _/ _/ _/ Inc.
|> _/_/_/_/ _/_/_/_/ _/ eMail: sinues_at_prcd.prc.mrms.navy.mil
|> _/ _/ _/ _/ Phone: (804) 498-5666
|> _/ _/ _/ _/_/_/_/ Fax: (804) 498-5670
|> ============================================================================
|>
 

-- 
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
E. Andrew Mondore                 Internet:  mondore_at_rpi.edu
Systems Programmer                Bitnet:    userfmc6_at_rpitsmts.bitnet
Rensselaer Polytechnic Institute