password of an user [message #492955] |
Thu, 03 February 2011 22:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/3f2b1fc1c77d7a5067b1abc9477a0a4d?s=64&d=mm&r=g) |
swadeshi
Messages: 15 Registered: January 2011 Location: Bangalore
|
Junior Member |
|
|
Hi please let me know how to set the value for the password.
for example please consider the below example.
ALTER USER scott IDENTIFIED BY VALUES 'F894844C34402B67'
how to set a password like jan2011 in values.
Thanks !!
|
|
|
|
Re: password of an user [message #492967 is a reply to message #492955] |
Thu, 03 February 2011 23:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:how to set a password like jan2011 in values.
You cannot, just remove "by values" and set it directly.
Why do you want to set it "by values" when you know the actual password?
Regards
Michel
[Updated on: Thu, 03 February 2011 23:30] Report message to a moderator
|
|
|
|
|