Password change
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Password change

  1. #1
    Join Date
    Oct 2000
    Posts
    57

    Hey guys,

    How will i change a user password from sqlplus prompt
    typing below syntax

    password <username>

    thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    alter user xyz identified by newpassword;
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2000
    Posts
    384
    in sqlplus just type password
    it will ask your oldpassword
    then it will ask your newpassword

    your password is changed..
    Radhakrishnan.M

  4. #4
    Join Date
    Oct 2000
    Posts
    57

    I am not able to change password typing password in sql prompt.

    Do you know the reason ?

    I am able to change using Alter user syntax,.

    thanks



  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    what version of sqlplus you are using ?

    I tried just before on SQL*Plus 8, it should work. Idin't want to change mine. thats why it was showing error message.

    <font face=courier>
    SQL> password
    Changing password for SREDDY
    Old password: *****
    New password: *****
    Retype new password: *****
    New passwords do not match
    Password unchanged
    </font>

  6. #6
    Join Date
    Jul 2000
    Posts
    296
    You need SQL*PLus (and database) 8.0 or higher.

  7. #7
    Join Date
    Oct 2000
    Posts
    57


    akkerend is right, thanks !



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