Re: Oracle password problem

From: neilsolent <n_at_solenttechnology.co.uk>
Date: Fri, 30 Oct 2009 06:14:27 -0700 (PDT)
Message-ID: <d2795af5-c906-459d-a0f1-2e537f33d22c_at_r5g2000yqb.googlegroups.com>

> > Neil
>
> SELECT USERNAME, ACCOUNT_STATUS
> FROM DBA_USERS
> 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
Thanks - worked. Users were there, problem was those single quotes (and my panic)

:) Received on Fri Oct 30 2009 - 08:14:27 CDT