Re: How to set user encoded password

From: Bob Yeh <Bob_Yeh_at_vaffx2_at_cscuuxch.dayton.csc.com>
Date: 1997/02/28
Message-ID: <3316FA20.2C99@cscuuxch.dayton.csc.com>#1/1

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

I think you mean alter user scott identified by values '73A46F3764F3746'. I tried in 7.3.2. It did not work MOST OF TIME(?).

Bob Received on Fri Feb 28 1997 - 00:00:00 CST