Ownership of objects with qualified names

If an object name is qualified, the type of object indicates its ownership.

Begin general-use programming interface information.If you create a table, view, index, or alias with a qualified name, the owner of the object is the schema name. The schema name identifies the schema to which the object belongs. You can consider all of the objects that are qualified by the same schema name as a group of related objects.

If you create a distinct type, user-defined function, stored procedure, sequence, or trigger with a qualified name, the owner of the object is the authorization ID of the process. The owner of a JAR (Java™ class for a routine) that is used by a stored procedure or a user-defined function is the current SQL ID of the process that performs the INSTALL_JAR function.End general-use programming interface information.