Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2009
    Posts
    2

    Unanswered: change user password without old password

    Please i am a newbie to sybase, i want to change a user password
    Not SA password just one of the users on the database.
    I know that i change the password as SA if i know the old password using the syntax below:

    sp_password oldpassword newpassword loginname


    How do i change or reset the user password if i do not know the old password or the user has forgotten the old password.

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    If you want to change your own password: sp_password oldpassword, newpassword
    If you want to change someone else's password, you have to have the SSO-role enabled for yourself:
    sp_password yourpassword, new_pasword_for_user_you_want_to_change loginname_of_user_you_want_to_change
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Mar 2009
    Location
    Sydney, Australia
    Posts
    258
    Yes.

    SSO stands for System Security Officer, that's different to System Administrator. If the original user has forgotten their password, only the SSO (not SA) can change their password.
    Regards
    Derek Asirvadem (Formerly DerekA)
    Information Architect / Senior Sybase DBA
    Copyright 2009 Software Gems Pty Ltd

    I answer questions from the Original Poster only. If you have a genuine question, as the moderators have requested, start a new thread.

    http://www.softwaregems.com.au

  4. #4
    Join Date
    Sep 2009
    Posts
    2
    Thank you for the response , I tried it and it worked

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •