DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: change user password

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    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

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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;

  3. #3
    Join Date
    Oct 2002
    Posts
    391
    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?

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    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.

  5. #5
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    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

  6. #6
    Join Date
    Oct 2002
    Posts
    391
    hi mate!
    i studied in brisbane too... in QUT...
    now working as SAP system administrator.

  7. #7
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    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

  8. #8
    Join Date
    Oct 2002
    Posts
    391
    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
  •  


Click Here to Expand Forum to Full Width