Here, I will explain you how you can see logs of users.
Step 2 : Create a new table.
Step 3 : Now, go and drop the table by running the following command.
Step 4 : Now, select your database under Object Explorer and go to Reports >> Standard Reports >> Schema Changes History.
Step 5 : You will then see the schema change history. The report will show you who has dropped this table.
Finally, you can locate the user activity with the help of log.