Exforsys.com
 
Home Tutorials Oracle 10g
 

Oracle 10g Free Training- Administering and Managing Users

 

Oracle 10g Free Training- Administering and Managing Users - Page 3

Page 3 of 3


Manager Users


Similar to creating users, user accounts can be managed either through EM or directly through sqlplus.


Managing Users through sqlplus

You can use following command to change the password of the user



Figure 9. Change Password Sqlplus Window


Managing Users through EM

Following window which is same as figure5 can be used to modify the user through EM.



Figure 10. Manager User EM Window


Following screen can be used to change password, default tablespace attached to the user.



Figure 11. Manage User General Window



Frequently Asked Questions

  1. Can I create users through internet explorer in oracle 10g?
  2. What is the significance of proxy user?
  3. What is the significance of Consumer Group?
  4. Can I grant tablespace quota to a user using EM?
  5. What is the significance of attaching a profile while creating a user?


First Page: Oracle 10g Free Training- Administering and Managing Users


Read Next: Oracle 10g Free Training - Defining and Creating Tablespaces



 

 

Comments


usama paul said:

  how do i perform data import and export.i would be grateful if am put through this.
December 25, 2008, 3:45 pm

Gerardo said:

  I am installing oracle10g clustered blades san eva win2003 64 and linux :several times get an error being I missed the script steps (missed a line) after that or at the end I get an error can I fix (uninstall, etc)How?(steps)right now I had to re image blades and even san eva storage can you help thanks in advance for your help
March 1, 2009, 11:45 pm

ranjan said:

  I am installing oracle10g clustered blades san eva win2003 64 several times get an error being I missed the script steps (missed a line) after that or at the end I get an error can I fix (uninstall, etc)How?(steps)right now I had to re image blades and even san eva storage can you help thanks in advance for your help
March 20, 2009, 3:02 am

Bapi Samanta said:

  I have installed Oracle 10g successfully but I am not able to create users with privileges so I need your help about this area and also I have many other problems on Oracle 10g domain. I expect your best guidelines for fixing my problems in details.
April 5, 2009, 3:06 pm

Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    

Sponsored Links

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 
Partners -  Privacy and Legal Policy -  Site News -  Contact   Sitemap  

Copyright © 2000 - 2009 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape