On Tue, 06 May 2008 03:03:22 -0400, Neil Jones
<castellan2004-atnews@[EMAIL PROTECTED]
> wrote:
Just checking.
You can apply SQL Server security to revoke access to that table, then
create two views:
select * from SecretTable
and give access to the Mgmt group only
and:
select * from SecretTable
where Im****tantCustomerRecFlag = 0
and give access to Everyone.
-Tom.
>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
|
