Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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
Try this:
alter user scot identified values '73A46F3764F..'
-- ====================================================================== Dinar Dhond Manager of Application Design & Development Pharmaceutical Research Plus, Inc. Voice: 410-544-1601 877 Baltimore Annapolis Blvd. Fax: 410-315-7500 STE 200 Email: ddhond_at_prpi.com Severna Park, MD 21146 =======================================================================Received on Fri Feb 28 1997 - 00:00:00 CST