Logging into azure sql database

Yesterday we had a question that we are trying to find out. Out of nowhere, everything in the database has changed,

We know this update is without a where clause, but we are just a few developers. Therefore, if any of us did this, we would know that.

It was at a strange time of the day, very late at night, and only a few IP addresses were allowed on the server.

Is there a way to get a complete log with ips of all transactions on azure? Has anyone had a similar problem? could it be a breakthrough? Are there any software protections, scripts that we can add to limit this?

+4
source share
2 answers

ips ?

, , onpremises.. ... TLOG ( Azure ' t , , - ).

1.) , .

enter image description here

2.) sys.event_log (Azure SQL Database) DMV, . , . .

, Azure , ,

1.. SQL
2. , , - .

enter image description here

+1

,

, , .

0

Source: https://habr.com/ru/post/1664606/


All Articles