SQL scripts and database security. (Cyber Security)

Discuss why would writing a SQL script to capture login events be important in database security?  What other methods may be used to capture similar information?  How can this information be used as part of your efforts to keep the data secure?