RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Creating Users
«Prev
Next»
User Connectivity
Configuring Oracle
SID List Listener
Configuring Listener
Oracle Net Basic Concepts
Password Files
Necessary Password Files
Password Creation Process
Placing | Naming PW File
Creating Password File
Remote Login Password
Connecting Internal Password
DBA Privileges
Different DBA Roles
Connect Database
PW Files Data Dictionary
Rebuilding Password File
Manage PW Conclusion
Enterprise Manager
SQL Plus Worksheet
OEM Architecture
SQL* Plus CLI
Accept Prompt Commands
Spooling Printing Report
SQL Plus Line Editing Commands
Creating Users
Steps To Change Security Manager
Default Tablespaces
Drop User
What Objects does User Own
Managing User Roles
Types System Privileges
Granting System Privileges
With Admin Option Clause
session_privs View
Revoke Privileges Oracle
Managing System Privileges
Changing a user's Password - Exercise
Changing passwords
Objective:
Change a user's password for the
COIN
database.
Exercise scoring
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.
Background and Overview
You are the DBA of the
COIN
database. The
COIN_ADMIN
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.
Instructions
Write the necessary SQL statement or statements, to change the
COIN_ADMIN
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.
Hints
The
ALTER USER
command is used for both parts of this exercise.
Submitting your exercise
Enter your answer into the text box below. Click the
Submit
button to submit the code.
Submit