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};