Data Base Tips/ SQL Commands...

Thursday, August 11, 2005

Easily change your Oracle password


From Oracle 8 on, you can use the command:

SQL> password

in SQL*Plus to easily change your password. By using

SQL> password <username>

you can change the password of another user.
This method has the advantage that the new password is not echoed on the screen.


3 Comments:

  • At 2:46 AM, Blogger Diabolic Preacher said…

    hi archu,
    it's been a real long time since i got back to this site...last time being probably when i followed the links from your ilug-goa post.

    looks like you've put so much effort and that also with no catch for a not so free (i presume) database backend.

    also looks like not many comments are hitting the site, although it's surely hell of a resource for any person trying their hands on such stuff.

    i don't even have oracle or even dbms as a subject yet, so i'll post my obligatory "thank you" once the course starts. :)

     
  • At 8:54 AM, Blogger Archu said…

    There was a time in my life when i was sucha SQL freak, i was really mad about sql. so i started to learn it to max and also get certified. but later i came to know more about OS Dbs. But i was not having much of my time as i had before to explore these things as i did for oracle. :)

     
  • At 8:55 AM, Blogger Archu said…

    Thanks for dropping over here :)

     

Post a Comment

<< Home