Writing Security Scripts

Security scripts are SIL scripts that return a specific format. The basic syntax for a security script is this:

return {<SET true/false>, <INSERT true/false>, <UPDATE true/false>, <DELETE true/false>};

With the SIL scripts you can create complex permissions schemes based on groups, project roles, etc. In the example below only a member of the “data-managers” group has permission to edit the values in the database:

boolean SET = true;
boolean INSERT = false;
boolean UPDATE = false;
boolean DELETE = false;

if(isUserInGroup("data-managers", currentUser())) {
    INSERT = true;
    UPDATE = true;
    DELETE = true;
}

return {SET, INSERT, UPDATE, DELETE};