scary stuff when you minimal privileges
I recently connected to my database as a new user with minimal privileges (just data_reader). Later I went to SQL Source control to see changes (forgetting I was logged in as the restricted user) and the output was scary - every SP was marked as deleted and most tables were marked as edited (text replaced with 'encrypted').
I didn't have the courage to hit commit just to see what happened - it was too scary seeing my entire database marked for deletion!
3
votes
anonymous
shared this idea
-
lakeland commented
Oops, that was by me sorry - forgot to log in