Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle NULL vs '' revisited

Re: Oracle NULL vs '' revisited

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 21 Aug 2007 11:40:07 -0700
Message-ID: <1187721607.401279@bubbleator.drizzle.com>


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.org
Received on Tue Aug 21 2007 - 13:40:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US