Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
trig_i_u_syst_perms() 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_perm_roles() 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_perm_role_grants() 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
get_greatest_rights_scope(p_scopes text[] DEFAULT NULL::text[]) FUNCTION sql true text DEFINER

Given an array of Permission Right Scopes, returns the most expansive scope found in the array.

Parameters

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

    The array of permission scopes to test.

General Usage

If the array is NULL the returned value is ‘deny’.
trig_i_i_syst_perm_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_d_syst_perms() 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_perm_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_perm_role_grants() 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_perm_role_grants() 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_perm_roles() 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_perm_roles() 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_perm_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_i_syst_perms() 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