Re: Oracle password problem
Date: Fri, 30 Oct 2009 05:39:22 -0700 (PDT)
On 30 Oct, 10:58, neilsolent <n..._at_solenttechnology.co.uk> wrote:
> Hi Gazzag
> > > Also - I could not change the sys or system password (it's almost as
> > > if those accounts have been deleted! Could they have been?)
> > What did you try and what happened?
> alter user 'system' identified by 'password1';
> I can't remember the error - sorry should have clocked it (been in a
> bit of a panic with this).
> Is there a simple command a normal user can run to just check these
> user accounts are there perhaps?
SELECT USERNAME, ACCOUNT_STATUS
WHERE USERNAME LIKE 'SYS%'; Additionally, you don't want the quotes in your ALTER USER command. ie.
ALTER USER SYSTEM IDENTIFIED BY <new_password>;
HTH -g Received on Fri Oct 30 2009 - 07:39:22 CDT