Re: What tables are schema passwords stored in?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 23 Sep 1998 19:13:43 +0200
Message-ID: <36092C45.587FACE4@sybrandb.demon.nl>

I'm not sure why you want do it this way. This method is definitely unsupported by Oracle, as it probably will ruin your data dictionary. It should be easy to do it in pl/sql by means of a call to dbms_sql. This will enable you to issue an alter user identified by ....
If you already have the encrypted password (how did you got the encryption algorithm, as far as I know it is not published) you can use
alter user identified by values '...encrypted password'

Thanks,
Sybrand Bakker, Oracle DBA

lancecarver_at_my-dejanews.com wrote:

> I am trying to directly (at the table level) change a schema's password. When
> I change the user$.password column to the new encrypted value, the password
> still doesn't take. Does anyone know what tables the password field is
> stored in (v7 and v8)?
>
> Thanks.
>
> Lance Carver
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Sep 23 1998 - 12:13:43 CDT