Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
trig_i_i_syst_instance_type_applications() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_d_syst_access_account_instance_assocs() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_u_syst_disallowed_passwords() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_d_syst_instances() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_d_syst_instance_type_applications() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_u_syst_enum_functional_types() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_i_syst_credentials() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_u_syst_credentials() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_u_syst_owners() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_d_syst_instance_network_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_d_syst_enums() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_i_syst_global_password_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_i_syst_instance_network_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

get_applied_network_rule(p_host_addr inet, p_instance_id uuid DEFAULT NULL::uuid, p_instance_owner_id uuid DEFAULT NULL::uuid) FUNCTION sql false TABLE(precedence text, network_rule_id uuid, functional_type text, ip_host_or_network inet, ip_host_range_lower inet, ip_host_range_upper inet) DEFINER

Applies all of the applicable network rules for a host and returns the governing record for the identified host.

The returned rule is chosen by identifying which rules apply to the host based on the provided Instance related parameters and then limiting the return to the rule with the highest precedence. Currently the precedence is defined as:

  1. Disallowed Hosts: Globally disallowed or “banned” hosts are always checked first and no later rule can override the denial. Only removing the host from the syst_disallowed_hosts table can reverse this denial.

  2. Global Rules: These are rules applied to all Instances without exception.

  3. Instance Rules: Rules defined by Instance Owners and are the most granular rule level available (p_instance_id).

  4. Instance Owner Rules: Applied to all Instances owned by the identified Owner (p_instance_owner_id).

  5. Global Implied Default Rule: When no explicitly defined network has been found for a host this rule will apply implicitly. The current rule grants access from any host.

Parameters

  • p_host_addr :: Required? True; Default: ( No Default )

    The host IP address for which to retrieve a network rule to apply.

  • p_instance_id :: Required? False; Default: NULL

    The record id of the Instance that the host is attempting to access.

    Note that NULL is a valid value subject to the conditions in the function description.

  • p_instance_owner_id :: Required? False; Default: NULL

    The record id value of the Owner record which owns the Instance.

    Note that NULL is a valid value subject to the conditions in the function description.

General Usage

This function returns the best matching rule for the provided parameters. This means that when p_host_addr is provided but neither of p_instance_id or p_instance_owner_id are provided, the host can only be evaluated against the Disallowed Hosts and the Global Network Rules which isn’t sufficient for a complete validation of a host’s access to an Instance; such incomplete checks can be useful to avoid more expensive authentication processes later if the host is just going to be denied access due to global network rules.

Providing only p_instance_owner_id will include the Global and Owner defined rules, but not the Instance specific rules. If p_instance_id is provided that is sufficient that is sufficient for testing all the applicable rules since the Instance Owner ID can be derived using just p_instance_id parameter.

trig_i_u_syst_instance_type_applications() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_i_syst_owner_network_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_u_syst_instances() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_i_syst_disallowed_hosts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_i_syst_instance_type_contexts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_u_syst_owner_password_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_d_syst_disallowed_hosts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_u_syst_instance_type_contexts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_d_syst_owners() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_u_syst_access_account_instance_assocs() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_d_syst_enum_items() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_i_syst_applications() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_i_syst_access_account_instance_assocs() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_i_syst_global_network_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_u_syst_owner_network_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_d_syst_global_network_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_d_syst_instance_contexts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_d_syst_disallowed_passwords() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_u_syst_global_password_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_i_syst_enums() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_u_syst_enum_items() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_i_syst_owners() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_u_syst_password_history() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_d_syst_identities() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_u_syst_enums() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_d_syst_owner_network_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_i_syst_enum_items() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_d_syst_global_password_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_i_syst_access_accounts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_d_syst_applications() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_d_syst_owner_password_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_i_syst_instances() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_u_syst_instance_network_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_u_syst_application_contexts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_d_syst_password_history() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_u_syst_applications() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_d_syst_credentials() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_i_syst_enum_functional_types() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_i_syst_identities() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_i_syst_application_contexts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_i_syst_instance_contexts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_i_syst_owner_password_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_d_syst_enum_functional_types() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_u_syst_instance_contexts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_u_syst_access_accounts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_d_syst_application_contexts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_u_syst_identities() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_u_syst_global_network_rules() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_d_syst_instance_type_contexts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_d_syst_access_accounts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: DELETE

trig_i_u_syst_disallowed_hosts() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: UPDATE

trig_i_i_syst_password_history() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT

trig_i_i_syst_disallowed_passwords() FUNCTION plpgsql false trigger DEFINER

Processes incoming API View requests according to globally applicable business rules and data validation requirements.

Trigger Function Details:

  • Supported Timing: INSTEAD OF

  • Supported Operations: INSERT