Entering content frame

Background documentation Access to Objects Locate the document in its SAP Library structure

The SQL syntax elements for Oracle Version 7 and MaxDB in ORACLE Structure linkSQL 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 Structure linkuser 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 Structure linksynonyms.

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

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

 

Leaving content frame