change user password

hi, i want to change a user password.
but after connect internal, i do not know which table to use?

so basically got two questions
1) which table name contains the list of users and passwords?
2) in oracle, how to we know all the list of system tables and their purposes?

thanks

1) dba_users
2) select * from dictionary; Read a lot of books; Read Oracle documentation; Practice.

You don't use a table to change a user's password. The dba_users table stores a 16-character encrypted string that represents the user's password. You do not update this table.

alter user username identified by password;
create user username identified by password;

alter user username identified by password;

if i want to change the password for the user 'system', the new password will be in the statement 'identified by PASSWORD', right?

alter user system identified by my_new_password;
create user clinton identified by womanizer;
alter user clinton identified by liar;

Quote:

---

Originally posted by stecal
alter user system identified by my_new_password;
create user clinton identified by womanizer;
alter user clinton identified by liar;

---

He he.. I love the example.

hi mate!
i studied in brisbane too... in QUT...
now working as SAP system administrator.

Great, I am crazy about Oracle and SAP.

wonderful, i can learn from you .... i am sure.. ;D