Database Reference
In-Depth Information
Figure 23.3
Change the
Password with the
ALTER USER
Command.
Now let's change the password for Jackie. If not already logged in as
JACKIE, then the first command will do that:
CONNECT JACKIE/J25RX@OLTP;
Now let's change Jackie's password to JACKIE001:
ALTER USER JACKIE IDENTIFIED BY JACKIE001;
You could then test the change by reconnecting with the new password:
CONNECT JACKIE/JACKIE001@OLTP;
Now we could reconnect to the SYSTEM user to practice changing
another user's password:
CONNECT SYSTEM/password@OLTP;
We could once again change Jackie's password by running the same
command that Jackie ran. This time, change the password to JACKIE#1:
ALTER USER JACKIE IDENTIFIED BY JACKIE#1;
We could verify Jackie's new password by connecting with the new pass-
word:
CONNECT JACKIE/JACKIE#1@OLTP;
