Andrew Rawnsley <ronz@ravensfield.com> writes:
> Schemas are users in Oracle, but the net effect to the SQL author is
> the same. 'SELECT * FROM SERVICES.USERS' is the same, just that
> 'SERVICES' is a user in oracle (although referred to as a schema, and
> you have to do a 'CREATE SCHEMA AUTHORIZATION blablabla' to get
> anything to work.
Oracle is actually SQL-spec-compliant in this regard (or possibly I
should say the spec is Oracle-compliant, seeing that they probably
dictated these semantics...) The SQL spec is carefully written
so that an implementation that enforces one-to-one matching of
schemas and users is spec-compliant.
regards, tom lane
