Re: How to set user encoded password

Andrew Protasov wrote:
>
> Hi all,
>
> Does anybody remember discussion how to set user password in
> internal format as it is stored in SYS.DBA_USERS. This is
> undocumented feature and looks something like
> alter user scott identified externally('73A46F3764F3746');
> But I don't remember exact syntax and in which versions this works.
> Maybe anyone changed password this way?
>
> Andrew Protasov

The sintax is

  ALTER USER scott IDENTIFIED BY VALUES '73A46F3764F3746';

About versions: I tested it on 7.1 and 7.2. For others, you will have to try yourself.

Regards, Jure

-- 
 ===============================================================
 ! Jurij Modic                            Republic of Slovenia !
 !  tel: +386 61 178 55 14                Ministry of Finance  !
 !  fax: +386 61  21 45 84                Zupanciceva 3        !
 !  e-mail: jurij.modic_at_mf.sigov.mail.si  Ljubljana 1000       !
 ===============================================================