开发者

What is the owner in a oracle database?

开发者 https://www.devze.com 2023-03-15 22:53 出处：网络

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 nam

相关专题：database-schema oracle owner

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

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.