Re: Forgot password for user "sys"

 In article 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?
 

Run SQL*DBA and CONNECT INTERNAL. This logs you in as SYS.

To be able to connect internal, you need:

On VMS:

        to have the ORA_DBA rights identifier
On UNIX:

        to be a member of the 'dba' group

$ SQLDBA
SQLDBA> connect internal

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285