"Audit Object Derived Permission Event" doesnt work as documented
- From: "Prasad" <prasad.ekke@xxxxxxxxx>
- Date: 9 Jan 2007 20:51:38 -0800
Hi,
I want to capture the Create, Alter and Drop Events of all the database
objects, and in addition to that I have other events too.
I was trying to use the "Audit Object Derived Permission Event" event
for capturing the Create, Alter, Drop of Tables, SP's and Views. But it
doesnt capture the Create event while its documented that it should do
so. It captures the Alter and Drop Event as expected.
Web Reference :
http://msdn2.microsoft.com/en-us/library/aa173905(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/aa173910(SQL.80).aspx
As seen from the above pages it is evident that microsoft says it
should get audited, but it doesnt, does anybody has a clue as to what
is wrong.
Note: I could have used the Object:Created Event but I needed the
database name also which according to the documentation will not given
by the trace.
.
- Prev by Date: Re: How to recover after restoring over a wrong database
- Next by Date: Re: Definition: A Catalog vs. a Database?
- Previous by thread: Encrypting information put into the database
- Next by thread: Error message Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
- Index(es):
Relevant Pages
|
|
