Routines

Routines

Name Type Language Deterministic Return Type Security Restriction Comments
trig_b_iu_syst_perm_role_grants_default_scopes() FUNCTION plpgsql false trigger INVOKER

This trigger will assign default Permmission Scope values based on the definition of the permission defined in Permissions’ ms_syst_data.syst_perms record.

Trigger Function Details:

  • Supported Timing: BEFORE

  • Supported Operations: INSERT, UPDATE
trig_a_iu_syst_perm_role_grants_related_data_checks() FUNCTION plpgsql false trigger INVOKER

Checks that Permission Role Grant records are consistent with their defining parent records.

Trigger Function Details:

  • Supported Timing: AFTER

  • Supported Operations: INSERT, UPDATE