update dba_users issue

today I found new things regarding dba_users. I cant directly update dba users and if i do so, it will give an error.

SQL> select username, password from dba_users;

USERNAME PASSWORD
—————————— ——————————
GEMS_READ 6011CE6AFCA47CEA

SQL> update dba_users set password =’DF0FA395F75E2285′ where username = ‘GEMS_READ’;
update dba_users set password =’DF0FA395F75E2285′ where username = ‘GEMS_READ’
*
ERROR at line 1:
ORA-01779: cannot modify a column which maps to a non key-preserved table

so I start Google and found the way to update it.

Instead of update the dba_users, I update user$ table.

SQL> update user$ set password=’6011CE6AFCA47CEA’ where name = ‘GEMS_READ’;
1 row updated.

But that is the hardest way, the easiest way is:
Login as sysdba then,

SQL> alter user GEMS_READ identified by values ‘6011CE6AFCA47CEA’;
1 row updated.

Source:
red-database-security