Updated on 2025-03-13 GMT+08:00

Object Access Programming Specifications

  • [Rule] When operating an object, a user should have operation permissions on the object.

    For details about the permission description, see Users and Permissions and comply with Permission Design Specifications.

  • [Rule] Use schemaname.tablename to access objects (such as tables and functions).

    If the schema name prefix is not added, the system searches all tablespaces in the current search_path until a matched table is found, which causes unnecessary performance overhead.