I Changed one of our user password. I got statement processed, But when i tried to logon as that user then it's telling me logon denied. Then i changed the password little bit and it's working. So i realized there is a problem with the password. If any body have any idea then please let me know. Thanks.
>ALTER USER SCOTT IDENTIFIED BY ERICAMY8;