Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Re: How to impl...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 8 Topic 11019 of 11409
Post > Topic >>

Re: How to implement Audit/Alert for Row level access?

by Neil Jones <castellan2004-atnews@[EMAIL PROTECTED] > May 6, 2008 at 03:03 AM

Ok.  Well, actually anyone user can access the data in the table.  We 
would like to monitor the access to the  flagged customers.

NJ

Tom van Stiphout wrote:
> On Mon, 05 May 2008 21:09:00 -0400, Neil Jones
> <castellan2004-atnews@[EMAIL PROTECTED]
> wrote:
> 
> You may have a logic error in your question, because if your assertion
> "can be accessed only by applications designed for upper management"
> is true, then obviously no one else has successfully accessed the
> flagged customers.
> 
> -Tom.
> 
> 
>> Hello,
>>
>> We have a large database of our customers.  Some of the im****tant 
>> customers records are flagged and can be accessed only by applications 
>> designed for upper management.  The management would like to know if 
>> anyone else is trying or successfully accessed the flagged customers.
>>
>> Is there anyway to send an email alert when a normal user/sysadmin
tries 
>> to access the flagged customers in the table?
>>
>> Thank you in advance for any help.
>>
>> NJ
 




 8 Posts in Topic:
How to implement Audit/Alert for Row level access?
Neil Jones <castellan2  2008-05-05 21:09:00 
Re: How to implement Audit/Alert for Row level access?
Tom van Stiphout <no.s  2008-05-05 22:08:44 
Re: How to implement Audit/Alert for Row level access?
Neil Jones <castellan2  2008-05-06 03:03:22 
Re: How to implement Audit/Alert for Row level access?
Tom van Stiphout <no.s  2008-05-06 06:43:13 
Re: How to implement Audit/Alert for Row level access?
--CELKO-- <jcelko212@[  2008-05-06 08:54:15 
Re: How to implement Audit/Alert for Row level access?
Lennart <Erik.Lennart.  2008-05-06 10:14:29 
Re: How to implement Audit/Alert for Row level access?
Erland Sommarskog <esq  2008-05-06 21:53:33 
Re: How to implement Audit/Alert for Row level access?
--CELKO-- <jcelko212@[  2008-05-07 09:40:34 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Oct 6 16:15:50 CDT 2008.