I am using Sqlserver 2005 and now i want to implement security as below
We have access to live database of client to give backend support. Hence there is a possibility that we suuport team can delete data from live database by mistake from management studio which i wan to restrict. How can i do this?
Is it possible to keep some password exclusively for that database so that when deleting/inserting/updating data it will ask password as an alert?
Thanks in advance Usha