We typically recommend that you create a read-only trevor database user that Trevor can connect as. You can do this easily by running the below commands against your SQL Server database:
-- STEP 1. Create user
CREATE LOGIN trevor WITH PASSWORD = 'secure_password';
CREATE USER trevor FOR LOGIN trevor
-- STEP 2. Grant select permissions
GRANT SELECT TO trevor;
Please sign in to leave a comment.