You can use the SQL Audit guard.

Regards

Rajkumar

I would sugguest that the sensitive data thats is being restored to dev/uat should be masked or encrypted.

Also a strong level of auditing  should be turned on for the production servers....

When you connect linked server from your workstation it will use Double Hop method. Hence you need to check the below steps.

1. Check the SPN registered...