Who created that user?

Posted by AaronBertrand on SQL Blog See other posts from SQL Blog or by AaronBertrand
Published on Wed, 02 Feb 2011 22:35:00 GMT Indexed on 2011/02/04 23:31 UTC
Read the original article Hit count: 235

Filed under:

auditing

|

default trace

Twitter has provided some great fodder for blog content lately. And twice this week, I've found an excuse to take advantage of the default trace. Tonight @meltondba asked: I'm trying to find who created a user act in a DB It is true, SQL Server doesn't really keep track of who created objects, such as user accounts in a database. You can get some of this information from the default trace, though, since it tracks EventClass 109 (Audit Add DB User). If you run this code: USE [master] ; GO CREATE LOGIN...(read more)

© SQL Blog or respective owner

Related posts about auditing

Unified Auditing - Das neue Auditing in Oracle Database 12c

as seen on Oracle Blogs - Search for 'Oracle Blogs'
In Datenbanken werden fast immer vor allem wichtige Informationen abgelegt. Der Zugriff darauf unterliegt in der Regel gesetzlichen oder betrieblichen Auflagen. Weil der Nachweis, dass diese Auflagen eingehalten werden, ausschliesslich über das Auditing möglich ist, ist eine Datenbank ohne Auditing… >>> More
What tool or scripts do you use to audit a Linux box?

as seen on Server Fault - Search for 'Server Fault'
I use the following tools for my auditing needs A) System Auditing and Hardening (One time) 1) Linux Security Auditing Tool (Security centric,Text based output ) 2) Dmidecode ( Retrieves info from BIOS ) 3) Systeminfo ( Generates a nice html report) 4) Syssumm (Inactive since Oct 2000) 5) Rootkit… >>> More
Database Level Auditing with Microsoft SQL Server 2008

as seen on Internet.com - Search for 'Internet.com'
MAK shows us how easy it is to create a database level audit, test the audit and retrieve the audit records in Microsoft SQL Server 2008. >>> More
Setting default auditing as recommended by Oracle

as seen on Internet.com - Search for 'Internet.com'
If you dont know where to start when setting Oracle auditing parameters, just start with what Oracle recommends. In this article, we set the default auditing as recommended by Oracle. >>> More
Auditing made easy by Microsoft SQL Server 2008

as seen on Internet.com - Search for 'Internet.com'
Microsoft SQL Server 2008 made the life of a DBA easier by providing an enhanced auditing feature, "SQL Server Audit". The first article of this series illustrates the various components for auditing and the action groups provided by Microsoft SQL Server 2008. >>> More

Related posts about default trace

Learn Who Started that Trace with the Default Trace

as seen on SQL Blog - Search for 'SQL Blog'
This is not Extended Event related but it came from a question on Twitter about how to tell who and from what machine a server side trace was created, and there is no way to explain this in 140 characters so here’s a blog post. This information is tracked in the Default Trace and can be found… >>> More
MySQL Database Query Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I need your help!!!. I need to query a table in my database that has record of goods sold. I want the query to detect a particular product and also calculate the quantity sold. The product are 300 now, but it would increase in the future. Below is a sample of my DB Table #---------------------------- #… >>> More
vagrant up command very slow on OS X Lion

as seen on Server Fault - Search for 'Server Fault'
When I run vagrant up to provision a new VM on Lion it takes an extremely long time, during which the entire Mac is very laggy and unresponsive. The output is as follows, the key point being the "notice: Finished catalog run in 754.28 seconds" > vagrant up [default] Importing base box 'lucid64'… >>> More
converting mysql database to sql server

as seen on Stack Overflow - Search for 'Stack Overflow'
i have a mysql database: /* MySQL Data Transfer Source Host: 10.0.0.5 Source Database: jnetdata Target Host: 10.0.0.5 Target Database: jnetdata Date: 5/26/2009 12:27:33 PM */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for chavrusas -- ---------------------------- CREATE… >>> More
Autoconf/Automake "configure.ac:2: option `-Wall' not recognized"

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello I'm trying to start with autoconf / automake for a new project. To get started, I'm reading "Using GNU Autotools" and trying to build the Hello-World-Tutorial. The required files from page 96 (real Page=105 because it's a LaTeX-Presentation) configure.ac, Makefile.am and src/Makefile.am look… >>> More