2

When talking about relational database the concepts I've learned are that there exists schema, table, attribute. We can prefix the table name with the schema name and the attribute with the table name (even incl. schema).

When looking on an Oracle database I see things calls "OWNER". Is this the way Oracle calls its schema, or how should I interpret them?

Best, Will

Will
  • 2,858
  • 6
  • 33
  • 50

1 Answers1

3

A schema is tied to a specific Oracle user. If I create a new Oracle user, a corresponding schema is created to hold all of that user's objects.

This is why the ALL_OBJECTS table and similar tables have an OWNER field, as it designates the user that created the object, and therefore which schema it resides in.

Datajam
  • 4,141
  • 2
  • 23
  • 25
  • Ok, then there is a OWNER called PUBLIC that is the schema for all users? – Will Jun 29 '11 at 13:44
  • 1
    Public is a special user. If you want to grant privileges to all users of the database you grant them to PUBLIC. – Rene Jun 29 '11 at 13:56