August 29, 2019 at 3:36 pm
Hi All,
Someone has dropped a table from azure database and i want to track who did it.
afaik, it's not possible out-of-the-box in Azure.
How to know the which user can drop my table in azure database.
For example, users with either granted control to the appropriate db schema or members of db_owner group.
It depends on security model implemented in your db.
August 29, 2019 at 4:16 pm
SELECT
Operation,
[Transaction Id],
[Transaction SID],
[Transaction Name],
[Begin Time],
[SPID],
Description
FROM fn_dblog (NULL, NULL)
WHERE [Transaction Name] = 'DROPOBJ'
is not available in Azure?
August 29, 2019 at 4:44 pm
The object drop events are logged in the default trace, and from there you can get date/time, session login name, etc.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 30, 2019 at 10:07 am
The object drop events are logged in the default trace, and from there you can get date/time, session login name, etc.
Default trace is not available in Azure SQL db.
August 30, 2019 at 10:11 am
SELECT
Operation,
[Transaction Id],
[Transaction SID],
[Transaction Name],
[Begin Time],
[SPID],
Description
FROM fn_dblog (NULL, NULL)
WHERE [Transaction Name] = 'DROPOBJ'
is not available in Azure?
It's an option, but when you have no control over backups (log backups, for instance), the chance to get the info is very little, depending on activity in your database.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply