Home arrow Oracle arrow Page 2 - Working With Oracle on Windows: Part 3

Working With Oracle on Windows: Part 3

This article is a quick summary of basic SQL commands with a little touch of Oracle to prepare for application development.

Author Info:
By: Ben Shepherd
Rating: 4 stars4 stars4 stars4 stars4 stars / 14
March 10, 2003
  1. · Working With Oracle on Windows: Part 3
  2. · Getting ready to use Oracle
  3. · SQL Summary
  4. · Conclusion

print this article

Working With Oracle on Windows: Part 3 - Getting ready to use Oracle
(Page 2 of 4 )

Since the Oracle 9i Database is installed onto your system, it would be handy to have your on account (i.e. your own schema). Open SQL*Plus in Windows by Start -> Programs->Oracle - OraHome92->Application Development->SQL*Plus.

To login type Scott in as the user with the password tiger. This is the default user created by Oracle. To see the users in the system simply type,

select * from all_users;

The display should return the following,

We see that there are 30 users currently on the system. You can see that Scott was created when the Oracle was installed. It has a user id of 59. Scott doesn’t have permission to create a new user, so I will connect on as the system’s database administrator. While I’m in the SCOTT/TIGER schema I’ll connect as a sysdba by the following,

Now I have permission to most tasks in the system. But I want to have a user to do this. So, I’ll create a user using the sysdba user, since now I have the power to do so.

Let’s check to see if the new user is there. Again we type

select * from all_users;

The result is,


We have now created a user with the name ben_shepherd and identified by the password “ben_shepherd”. Well, the reason I have given the future database administrator a password is pretty straight forward. We wouldn’t like to have an intruder posing as the DBA. The user_id has been assigned as 61 and the date created was today.

The user is created but with no power to do anything. Hence we will assign a sysdba role to him by,

User ben_shepherd is now able to do all the tasks that will be performed in this series of articles. He will also create a user, down the track, to access a website’s database that we will create. Ok, I am starting think that you are ready for the next step.

blog comments powered by Disqus

- Oracle Purchases Taleo to Extend Cloud Compu...
- Partitioning in Oracle. What? Why? When? Who...
- Datatypes Used in Oracle 9i
- Creating a Database in Oracle 9i
- Oracle with Doctor Janusz Getta
- Working With Oracle on Windows: Part 3
- Working With Oracle on Windows: Part 2

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials