I have a user which needs to be able to write one specific lookup table which has to be shared globally. I have to control with the permission settings on the lookup as I have several users/roles where each role has to grant write access to a different lookup table.
What i have observed so far: in order to be able to write a lookup table with | outputlookup xxxx.csv, the user needs the capabilityoutput_file. This capability is be default granted trough the predefined user role.
With the capability output_file, the permission configured in local.meta is ignored, outputlookup writes happily any lookup file, regardless of the permission, even files which don't exist.