Write SQL that will return the date

$-$

time and server

$\_$

principal

$\_$

name for all successful logins

$.$

$$From an audit perspective, why would you want to know when individuals

$/$

applications successfully log in

$?$

Write SQL that will return the date

$-$

time and server

$\_$

principal

$\_$

name for all failed logins

$.$

$$From an audit perspective why would you want to know when individuals

$/$

applications failed to log in

$?$

Write SQL that will return the date

$-$

time, target

$\_$

server

$\_$

principal

$\_$

name, server

$\_$

principal

$\_$

name for all login password changes. From an audit perspective why would you want to know when a login password was changed.

Write SQL that will return the date

$-$

time, database

$\_$

name, object

$\_$

name and statement for all new or created database users. From an audit perspective why would you want to know when a new database user is created?

Write SQL that will return the date

$-$

time and statement for all modified audits. From an audit perspective, why would you want to know when an audit is modified?