Audit Schema & Permission Changes

Quickly locate the transaction responsible for making changes to the database, schema, and permissions by viewing DDL commands

  1. Switch to Log Explorer and select the View DDL commands

  2. Refresh to view new transactions 

  3. Click on the SP_GRANTDBACCESS command

  4. This transaction granted the login 'Demo_Login' access to the database.

  5. Continue browsing and click on the ALTER_TABLE command

  6. This transaction altered the table 'employee' by adding the new column 'years'

 

Click 'Next' to continue.