Home arrow Oracle arrow 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.

TABLE OF CONTENTS:
  1. Oracle 10G XE User Management 101
  2. Creating Users
  3. Altering the User Account
  4. What if you are a first time user?
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 13
August 29, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

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.

Example 2

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.



 
 
>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: