Access to Objects

The SQL syntax elements for Oracle Version 7 and MaxDB in ORACLE SQL mode differ with regard to object access, among other things.

If a schema is not specified when a database object is accessed, and no object belonging to the current user exists with this name, the following procedure (which is different from Oracle) applies for MaxDB when the database object is accessed:

...

       1.      MaxDB searches for this object in the PUBLIC synonyms.

       2.      If the object was not found, MaxDB searches for this object in the part of the database catalog of the DBA user that the current user generated.

       3.      If the object was not found, MaxDB searches for this object in the database administrator’s part of the database catalog.