Skrevet av Emne: Oracle: How to change a user password  (Lest 2204 ganger)

ATC

  • Gjest
Oracle: How to change a user password
« på: 30. April 2009, 09:25 am »
  • [applaud]0
  • [smite]0
  • How do I change a user password in Oracle using SQL?



    ATC

    • Gjest
    [Solved] Oracle: How to change a user password
    « Svar #1 på: 30. April 2009, 09:25 am »
  • [applaud]0
  • [smite]0
  • ALTER USER 'yourName' IDENTIFIED BY 'newPassword';

    Note that SQL is completely case-insensitive. Once you are in sqlplus, you can use capitals or not in keywords like ALTER; Even your password is case insensitive. We tend to capitalize keywords and not other things.