SELECT Part I

This lecture introduces the most basic SQL statement to explore data, SELECT.

Open SQLPlus. You will be asked user credentials. Enter your credentials.

Let's create a user and specify password with the following command:
CREATE USER username IDENTIFIED BY password

Now we need to assign a role to our newly created user. You can limit the role to a plain user with CONNECT argument or add more with RESOURCE and DBA arguments.

Lastly, let's give creating session rights and some table space to our user:

If we want to connect with our new user credentials: