Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!newsfeed.cwix.com!nntp.abs.net!news.algonet.se!algonet!HSNX.atgi.net!mozo.cc.purdue.edu!canoe.uoregon.edu!logbridge.uoregon.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!newsbin.cistron.nl!not-for-mail From: Jared of Europa Newsgroups: comp.databases.oracle.server Subject: Re: Fine-grained Access Control and constraint violations Date: Fri, 08 Aug 2003 22:26:34 +0200 Organization: Cistron Netherlands Lines: 25 Message-ID: References: <945a3a61.0308080346.67708a83@posting.google.com> <3F33C69A.11BC8EEE@exxesolutions.com> NNTP-Posting-Host: cust.93.22.adsl.cistron.nl Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: enterprise.cistron.net 1060374393 616 195.64.93.22 (8 Aug 2003 20:26:33 GMT) X-Complaints-To: abuse@cistron.nl NNTP-Posting-Date: Fri, 8 Aug 2003 20:26:33 +0000 (UTC) X-Newsreader: Forte Agent 1.92/32.572 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240266 In this foul year of our lord Fri, 08 Aug 2003 08:49:46 -0700, Daniel Morgan proclaimed: >From my read of your posting you have thrown out all of the rules of >relational database theory taught in lesson one on databases. I must have been off sick when they taught lesson one :-) But seriously, which rules are violated here? Lesson one on coaching is that you tell a pupil *why* he's wrong, not just *that* he's wrong. Keep in mind that the requirement for a constraint on unique names is something that may change into a different constraint, or disappear, on some future date. >If you want this to work you will need to trash your design and go back to >doing things the way they were intended to be done in a relational >database. I'd start with reading Cobb. I would redesign if I could, but we're working on an existing, elaborate design. The client asks for security on the existing system, and telling him we'll need an extra 2 man-years for this job would not make him very happy. -*- Ronald In 't Velt