| Team Fly | |
FIGURE 3-9. User Management view
Once a user has been created, you will be asked at different times to edit users to change quotas or reset passwords or unlock an account. This can be easily performed through OEM by selecting the User, choosing the option you want to change through the Gui, and then applying the change.
Editing users can also be performed using the ALTER USER statement, as shown next, where a user account is unlocked, the password is changed, and a tablespace quota is increased.
ALTER USER ''username" IDENTIFIED BY "newpwd " QUOTA UNLIMITED ON TOOLS ACCOUNT UNLOCK;
We've now created a user and it's time to grant them some privileges. Let's see how we do this in the next section.
| Team Fly | |