Oracle Tutorial Part 2

Now we are going to connect to SQL Plus.

Using Window Vista, you will select programs->oraclehome1->application development->sql plus. Your console will open up and you will be prompted for a login and password. We need to login as the administrator the first time so you should input System as the login, and admin as the password. That is because we changed the password to admin when we installed the software. After you login you should see SQL>

To create a user you will type:

SQL>CREATE USER gdias IDENTIFIED BY greg;

You should always end your statements with a semicolin. If you see "User created" then you successfully created a new user with the login of gdias and password of greg.

We want to give this user full access and grant him DBA access.

Input this command to give the user DBA access.

SQL>GRANT DBA TO gdias;

You should see "Grant Succeeded".

Now we want to use the new user that we just created so we are going to connect to that database using the new username and password.

Type this command:

SQL>CONNECT gdias/greg;

Now you are connected with the new user.

Go To Part 3