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.
Next: SQL Summary >>
More Oracle Articles
More By Ben Shepherd
/ 11 
