Home > Ask the Oracle Database / Applications Experts > Questions & Answers > Changing the initial defaults of SYSTEM, adding privileges through GUI
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Changing the initial defaults of SYSTEM, adding privileges through GUI

Brian Peasland EXPERT RESPONSE FROM: Brian Peasland

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site
>
QUESTION POSED ON: 10 June 2002
I recently installed Oracle 8i on both the server and client. How do I change the initial defaults of System/manager? Also I need to set up some users with admin privileges, and some with user privileges like select, update and insert. Can these be done thru GUI?

>

To change any user's password, sign on to the database as a user with DBA privileges. The SYSTEM account will do. Then issue the following command:

ALTER USER username IDENTIFIED BY newpassword;
You'll want to substitute for the username and password above. This can all be done through a GUI. Oracle's GUI administration tool is called Oracle Enterprise Manager. You'll need to install that and configure it to correctly administer *any* aspect of the database, including user's passwords and privileges.

For More Information


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts