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