Oracle
  Home arrow Oracle arrow Page 4 - Oracle 10G XE User Management 101
Dev Shed Forums 
Administration  
AJAX  
Apache  
BrainDump  
DHTML  
Flash  
Java  
JavaScript  
Multimedia  
MySQL  
Oracle  
Perl  
PHP  
Practices  
Python  
Reviews  
Security  
Style-Sheets  
Web Services  
XML  
Zend  
Zope  
Forums Sitemap 
IBM® developerWorks 
Sun Developer Network 
E-Commerce Hosting 
Linux Web Hosting 
Managed Hosting 
Small Business Hosting 
Mobile Linux 
App Generation ROI 
VPS Hosting 
Weekly Newsletter

 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
ORACLE

Oracle 10G XE User Management 101
By: Jayaram Krishnaswamy
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 9
    2006-08-29

    Table of Contents:
  • Oracle 10G XE User Management 101
  • Creating Users
  • Altering the User Account
  • What if you are a first time user?

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Oracle 10G XE User Management 101 - What if you are a first time user?


    (Page 4 of 4 )

    In the very first tutorial the method for unlocking the HR user account was described. However this article is a more appropriate place. Since to start with there is only one login, that of the system, login with system as the user and the password created while installing Oracle 10G XE. After gaining entry to the database click on Administration and click on the Manage Users menu item which opens up the window shown next. You can see the HR user whose password has expired and note that the account is locked.

    Click on the HR icon to open the user's details as shown in the next window.

    Enter the password, hr. Confirm it by entering it again, use the drop-down to change HR's Account Status from Locked to Unlocked and click on the Alter User button. This brings up the next screen shown. Now the user hr can enter with the password hr and gain access to the database objects.

    Summary

    This tutorial is a 101 level administration "how-to" for managing users in Oracle 10G XE. It's a very easy to use interface for administering users. It is however very important to note down your password while installing. In addition to the roles that are discussed in the article, the machine also has entries for the Ora DBA group to which the users can belong -- as it happens, on Hodentek the user "jay" belongs to the ORA DBA group.


    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

       · This is really basic stuff. For a free database you cannot possibly hire a dba and...
     

       

    ORACLE ARTICLES

    - Implementing and Using Oracle`s Restore Poin...
    - Tuning PL/SQL Code
    - Debugging PL/SQL Code
    - Testing PL/SQL Code
    - Working With PL/SQL Code
    - Conditional Compilation for Oracle Database ...
    - Compile-Time Warnings for Oracle DB 10g
    - Compiling PL/SQL Code for an Oracle Database
    - Troubleshooting PL/SQL Code
    - Managing PL/SQL Code
    - Data Manipulation and More for HTML DB Appli...
    - Oracle Database Fundamentals
    - Adding Processes to HTML DB Applications
    - Adding Computations, Processes, and Validati...
    - Sub-templates and More with Oracle HTML DB





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway
    Stay green...Green IT