18 lines
876 B
SQL
18 lines
876 B
SQL
UPDATE salix.ACL
|
|
SET principalId = 'teamBoss'
|
|
WHERE property IN ('addTimeEntry', 'deleteTimeEntry', 'updateTimeEntry', 'weeklyHourRecordEmail');
|
|
|
|
UPDATE salix.ACL SET principalId = 'developer' WHERE property = 'sendMail';
|
|
|
|
UPDATE salix.ACL
|
|
SET property = 'updateMailState'
|
|
WHERE property = 'updateWorkerTimeControlMail';
|
|
|
|
INSERT INTO salix.ACL(model, property, accessType, permission, principalType, principalId)
|
|
VALUES
|
|
('WorkerTimeControl', 'addTimeEntry', 'WRITE', 'ALLOW', 'ROLE', 'hr'),
|
|
('WorkerTimeControl', 'deleteTimeEntry', 'WRITE', 'ALLOW', 'ROLE', 'hr'),
|
|
('WorkerTimeControl', 'updateTimeEntry', 'WRITE', 'ALLOW', 'ROLE', 'hr'),
|
|
('WorkerTimeControl', 'weeklyHourRecordEmail', 'WRITE', 'ALLOW', 'ROLE', 'hr'),
|
|
('WorkerTimeControl', 'sendMail', 'WRITE', 'ALLOW', 'ROLE', 'hr'),
|
|
('WorkerTimeControl', 'updateMailState', 'WRITE', 'ALLOW', 'ROLE', 'hr'); |