Re: Select count(*) in Oracle and MySQL

Mladen Gogala wrote:
On Sat, 29 Sep 2007 08:24:49 -0700, DA Morgan wrote:

And neither is worth anything if your organization happens to be subject
to any form of governmental or banking governance, auditing or
compliance regulation among them Sarbanes Oxley (SEC), HIPAA (DHHS),
Electronic Storage of Brokerage Dealer Records (SEC), FACTA (FTC), Gramm
Leach Bliley (FTC), Payment Card Industry Data Security Standard (PCI),
PIPEDA (Privacy Commissioner Canada), Basel II (Bank for International
Settlements), or numerous other rules and regs.

Unless, of course, you have auxiliary databases, not critical to the
company, or your company is not a publicly traded one. Joe's Bar & Grill
is not subject to any of those regulations and it still needs a database.

If Joe's Bar & Grill takes credit cards, and they do, they are subject
to PCI regulations which they agreed to when they signed the contract
with their bank.

Does Joe's do credit or background checks on employees as part of the
hiring process? If so they are subject to FACTA too.

Do they keep any customer records of any type that could potentially be
used for identity theft? If so they are subject to Gramm-Leach.

As they teach in law school:
Ignorantia juris non excusat
"ignorance of the law does not excuse"
or
Ignorantia legis neminem excusat
("ignorance of the law excuses no one")

I will grant the risk of prosecution is very low. But that is hardly
the standard to which one should aspire.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Re: Sarbanes-Oxley again
    ... it is not just roadmaps. ... My recollection of CFR 11 was that yes, it is very complex, but also that compliance needn't be and isn't as daunting as a reading of the regulations suggests it might or could be. ... Failing to interpret the law correctly such that you expend time, effort and money trying to comply with something that the law doesn't actually require you to comply with can equally lead to bankruptcy. ... and 2) if you are asking for a rule interpretation, ...
    (borland.public.delphi.non-technical)
  • Re: Youre Fired!
    ... course, named "Administrative Law," was mandatory. ... Securities regulations are not laws. ... that's what the courts do. ... It's not civil litigation; it's an administrative process. ...
    (alt.usage.english)
  • Re: The Problem with Misinformation
    ... Neither the lawbook nor the regulations of "many National authorities" ... misinformation when in fact his explanation is accurate (which includes ... ACBL Alert Procedures ... Law 75C requires you disclose your agreement. ...
    (rec.games.bridge)
  • Re: Sarbanes-Oxley again
    ... we cannot predict the interpretations and decisions of government officials ... *hope* that government will agree with your understanding of such a law? ... complying with phantom regulations "just in case". ...
    (borland.public.delphi.non-technical)
  • Re: OT religious content re anger over "holidays" vs. "Christmas"
    ... Until a higher court throws it out, the law stands intact in that ... >An example of restrictions on teachers' religious expression: ... regulations prevent teachers from displaying ... The Pennsylvania Public School code, ...
    (rec.outdoors.rv-travel)