Many times, for security reasons, we may want specific users to connect only from specific machines - servers, and in the event that a connection comes from a different machine, not allow access but display a rejection message.… read more
What are triggers?
Do they have overhead? Where is their utility? and finally how are they made? There are 3 different types: DDL triggers for CREATE / DROP actions, AFTER LOGON triggers for when a user logs in, DML triggers for Update, Insert, Delete actions. In the article… read more