HomeOracle Page 3 - Oracle 10G XE User Management 101
Altering the User Account - Oracle
If you're a DBA, one of your basic tasks involves managing users: dropping, adding, and changing permissions. Even if you aren't a DBA, if you use a database, you may find it helpful to know the tasks that a DBA performs. This article explains the basics for how to perform these tasks in Oracle 10G XE.
As an administrator you can manage users by clicking on Database Users and picking the Manage Users drop-down menu item as shown.
Clicking on Manage Users opens the Manage Database Users pane as shown where all users are listed.
Here we have a user named Charles. He is locked out of his account and he has asked the DBA to change some of his privileges. The DBA wants to access his account and change these items. The DBA logs on to the database, gets to the above screen, and clicks on the hyperlink of the user Charles. He gets the following page where he can make changes.
The DBA unlocks his account by using the drop-down. He can see that Charles can only create tables, and as requested by Charles he adds the other privileges by placing check marks in the required checkboxes; Create View, Create Procedure and Create Triggers. The DBA then clicks on the Alter User button. Next time Charles logs on he can gain admittance to the database objects he created as shown in the next picture. He can now create the other objects he wanted to create besides tables. On clicking the Alter User button the DBA gets a response that the USER was altered from the database (window not shown).
If the organization for which Charles works had asked the DBA to remove Charles from the database, the DBA could drop him using the DROP button, but before that he has to back up his data, if they are needed. The DBA can also make changes to the password. One safe way to do this is to expire the user's password, so that the next time Charles can create his own new password, but he has to use his old password to complete this process. The DBA can also give a new password to the user after expiring the password, but he will have to communicate the new password to the user.