Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle NULL vs '' revisited
euan.garden_at_gmail.com wrote:
>> Consider this for example. In a US medical environment with patient data
>> HIPAA, federal law, requires that SELECT statements be audited. We have
>> been able to do that in Oracle for years. InSQL Serverit is still
>> impossible. Something that won't be fixed until at least 2009. If I
>> tried to put together a page of all differences I would need months just
>> to catalog the differences.
>>
> > I'm sorry you lose again, I suggest you review SQL Trace with the C2 > option which has been available since SQL Server 2000.
Try again:
"while SQL Server 2000 can indicate which user might have updated a
table, it cannot capture the actual content of the update. Still, SQL
Server 2000 does conform with the C2-level auditing required by certain
government users."
http://www.itworld.com/AppDev/136/ITW010305talmage/
Next go to:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx#EJGAC
and scroll down to:
"List of Auditable Events"
If you are going to comment on a product ... take the time to learn something about it. According to Microsoft it can not meet HIPAA based on what is published on their website.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Aug 21 2007 - 13:40:07 CDT
![]() |
![]() |