Answer: To change a user's password in Oracle, you need to execute the alter user command.
The syntax for changing a password is:
user_name is the user whose password you wish to change.
new_password is the new password to assign.
For example:
If you wanted to reset the password for a user named smithj, and you wanted to set the new password to autumn, you would run the following command:
From [url]http://www.techonthenet.com/oracle/password.php[/url]
The syntax for changing a password is:
alter user user_name identified by new_password;
user_name is the user whose password you wish to change.
new_password is the new password to assign.
For example:
If you wanted to reset the password for a user named smithj, and you wanted to set the new password to autumn, you would run the following command:
alter user smithj identified by autumn;
From [url]http://www.techonthenet.com/oracle/password.php[/url]
本文介绍了如何使用Oracle数据库中的alter user命令来更改用户的密码。通过简单的语法示例,读者可以了解如何为特定用户设置新的密码。

1681

被折叠的 条评论
为什么被折叠?



