salix/db/changes/234001/00-aclClient.sql

43 lines
1.6 KiB
MySQL
Raw Permalink Normal View History

2023-09-07 07:03:25 +00:00
-- No encuentro este back
2023-09-21 08:41:20 +00:00
DELETE FROM `salix`.`ACL` WHERE property = 'activeWorkersWithRole';
DELETE FROM `salix`.`ACL` WHERE model = 'Client' AND property = '*';
2023-09-07 07:03:25 +00:00
2023-09-21 08:41:20 +00:00
INSERT INTO `salix`.`ACL` (model,property,accessType,permission,principalType,principalId)
2023-09-07 07:03:25 +00:00
VALUES ('Client','findOne','READ','ALLOW','ROLE','employee');
2023-09-21 08:41:20 +00:00
INSERT INTO `salix`.`ACL` (model,property,accessType,permission,principalType,principalId)
2023-09-07 07:03:25 +00:00
VALUES ('Client','findById','READ','ALLOW','ROLE','employee');
2023-09-21 08:41:20 +00:00
INSERT INTO `salix`.`ACL` (model,property,accessType,permission,principalType,principalId)
2023-09-07 07:03:25 +00:00
VALUES ('Client','find','READ','ALLOW','ROLE','employee');
2023-09-21 08:41:20 +00:00
INSERT INTO `salix`.`ACL` (model,property,accessType,permission,principalType,principalId)
2023-09-07 07:03:25 +00:00
VALUES ('Client','exists','READ','ALLOW','ROLE','employee');
2023-09-21 08:41:20 +00:00
INSERT INTO `salix`.`ACL` (model,property,accessType,permission,principalType,principalId)
2023-09-11 14:24:47 +00:00
VALUES ('Client','__get__addresses','READ','ALLOW','ROLE','employee');
2023-09-07 07:03:25 +00:00
2023-09-21 08:41:20 +00:00
DELETE FROM `salix`.`ACL` WHERE model = 'Client' AND property = '*' AND accessType IN (
2023-09-07 07:03:25 +00:00
'campaignMetricsEmail',
'campaignMetricsPdf',
'clientDebtStatementEmail',
'clientDebtStatementHtml',
'clientDebtStatementPdf',
'clientWelcomeEmail',
'clientWelcomeHtml',
'consumptionSendQueued',
'creditRequestEmail',
'creditRequestHtml',
'creditRequestPdf',
'getClientOrSupplierReference',
'incotermsAuthorizationEmail',
'incotermsAuthorizationHtml',
'incotermsAuthorizationPdf',
'letterDebtorNdEmail',
'letterDebtorNdHtml',
'letterDebtorPdf',
'letterDebtorStEmail',
'letterDebtorStHtml',
'printerSetupEmail',
'printerSetupHtml',
'sepaCoreEmail',
'setPassword',
'updateUser',
'uploadFile');