-
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;
Last edited by stecal; 11-13-2002 at 08:56 PM.
-
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.
OCP 8i, 9i DBA
Brisbane Australia
-
hi mate!
i studied in brisbane too... in QUT...
now working as SAP system administrator.
-
Great, I am crazy about Oracle and SAP.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
-
wonderful, i can learn from you .... i am sure.. ;D
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|