Managing DB Objects
SID List Listener
Remote Login Password file
SQL Plus Worksheet
SQL* Plus CLI
Accept Prompt Commands
Spooling Printing Report
SQL Plus Line Editing Commands
Steps To Change Security Manager
Changing a user's Password - Exercise
Change a user's password for the
This exercise is worth up to 10 points. You will get 5 points for the core task of changing the password. Another 5 points are awarded if the student figures out the bonus task.
You are the DBA of the
user has come to you, confessing that in his forgetfulness he has lost the password to his account. Worse yet, someone has stolen his written password list from his desk drawer, so now he cannot log in. He wants you to reset his password to something that he knows.
Write the necessary SQL statement or statements, to change the
user's password. For bonus credit, set the new password so that it is already expired. That way the user is forced to change it again, to a value that you do not know.
command is used for both parts of this exercise.
Submitting your exercise
Enter your answer into the text box below. Click the
button to submit the code.