Introduction to Users and Schemas

Contact Us or call 1-877-932-8228
Introduction to Users and Schemas

Introduction to Users and Schemas

  • A database user is identified by a unique user name and password combination. A user has a set of assigned security permissions which allow access and control of database resources.
  • A schema is a logical collection of database objects (tables, views, triggers, etc.) owned by a database user.
  • A schema has the same name as the user.
  • SQL Developer is a graphical interface for Oracle Databases.
  • SQL*Plus is a command line interface for Oracle Databases.
  • Double click on the menu option or SQL Developer icon.
  • Image of SQL Developer Icon
  • Wait while the splash screen displays.
  • Image of SQL Developer Icon
  • If you have not yet configured your connection:
  • Image of SQL Developer Icon
    1. Right-click on "Connections"
    2. Choose New Connection
    3. Enter the connection information
    4. Test the connection and make any needed corrections
  • Choose your connection and log in, using your oracle username (HR for instance) and password
  • sqlplus <user>/<password>@<database>
  • Note that queries need to be ended with a semi-color or a forward-slash.

Definitions and Client Tools

A database user is identified by a unique user name and password combination. A user has a set of assigned security permissions which allow access and control of database resources.

A schema is a logical collection of database objects (tables, views, triggers, etc.) owned by a database user.

A schema has the same name as the user.

SQL Developer is a graphical interface for Oracle Databases.

SQL*Plus is a command line interface for Oracle Databases.

SQL Developer Login

Double click on the menu option or SQL Developer icon.

Image of SQL Developer Icon

Wait while the splash screen displays.

Image of SQL Developer Icon

If you have not yet configured your connection:

Image of SQL Developer Icon

  1. Right-click on "Connections"
  2. Choose New Connection
  3. Enter the connection information
  4. Test the connection and make any needed corrections

Choose your connection and log in, using your oracle username (HR for instance) and password

To Log on to the HR schema using SQL*Plus.

sqlplus hr/hr@xe

You can start SQL*Plus without logging in to a database.

sqlplus /nolog

However, it is more common to connect using a connection string.

sqlplus <user>/<password>@<database>
Next