Database Objects

User Objects

If you select no schema prefix (none / connected user), the PL/SQL Connector Builder generates Java accessors for the connected user's procedures, functions, and packages. It also supports private synonyms in the connected user's schema that reference procedures, functions, or packages in other schemas. The synonym name must match the referenced object name.

Security: Best Practice

• Development: Connect with the owning schema user and access objects directly (no schema prefix).
• Production: Create a dedicated runtime user. For each required database object, create a private synonym in the runtime user's schema and grant EXECUTE on the target objects. Generate accessors using this runtime user.

Schema Prefix

If you select a schema prefix that is different from the connected user, the Connector Builder accesses procedures, functions, and packages in that schema directly. In this mode, private synonyms are not used. The connected user must have the required privileges on the target schema objects.

Public Synonyms

Public synonyms are not supported by the PL/SQL Connector Builder.