7 lines
372 B
SQL
7 lines
372 B
SQL
-- Grant permission to customer_statement.php for all users who have access to customers.php
|
|
INSERT IGNORE INTO user_permissions (user_id, page, can_view, can_add, can_edit, can_delete)
|
|
SELECT user_id, 'customer_statement.php', can_view, can_add, can_edit, can_delete
|
|
FROM user_permissions
|
|
WHERE page = 'customers.php'
|
|
ON DUPLICATE KEY UPDATE can_view = VALUES(can_view);
|