What is the owner in a oracle database?

oracle database-schema owner
Will picture Will · Jun 29, 2011 · Viewed 8.1k times · Source

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

Answer

Datajam picture Datajam · Jun 29, 2011

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.

Related questions

How to SELECT in Oracle using a DBLINK located in a different schema?

We have an Oracle DBMS (11g) and the following configuration: A DB user "MYUSER" Two schemas "MYUSER" and "SCHEMA_B" User "MYUSER" can access "SCHEMA_B" and has READ permissions on its tables A public DB link "DB_LINK" located …

Read More
grant select on view

somewhere along the way something is going wrong, and I can't seem to find out why. If this is already asked apologies. I have 3 schema's in my database: COLLDESK LOCAL_IT GERBEN COLLDESK is our main schema, LOCAL_IT is …

Read More
How to find foreign-key dependencies pointing to one record in Oracle?

I have a very large Oracle database, with many many tables and millions of rows. I need to delete one of them, but want to make sure that dropping it will not break any other dependent rows that point to …

Read More