While we are working with customer database we must need to ensure not any activity will work with live data
1 Answer
We should need to trigger below queries after restore customer database into local system or staging server
to inactive automatic action
Update ir_cron set active='false';
To set dummy email address into partner
Update res_partner set mailto:email='dummy@example.com';
To remove UUID key
Update ir_config_parameter set value='backup_db' where key='database.uuid';
To remove outgoing email server
Delete from ir_mail_server;
To remove incoming email server
Delete from fetchmail_server;
to update login_id and password for admin user
update res_users set login='admin' where id=2;
update res_users set password='admin' where id=2;