(Daljit S. Saini) Security audit in SQL Server captures only successful and failed logins. It does not capture the application that uses the login. The login used by an application may have full read and write access on all of the tables and procedures but the application itself restricts the users
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help