Re: super type & sub type, interested too

Hi Lennart

Lennart Jonsson schrieb:
> On Wed, 06 Nov 2002 21:43:30 +0100, Lennart Jonsson wrote:
>
> [...]
>
> Oh, another thing I have been thinking about regarding this. Has any one
> thought of ways/strategies to prevent someone from just adding a
> supertype, and not a subtype. I cant seem to come up with a clever way of
> doing this. Anyone else?

Probably one of the easiest ways would be to use a single stored procedure to insert a row in the supertype and the subtype and to revoke the grant for inserting records into the supertype table by users.

-- 
All emails sent to this address are never read and never will be
answered. Sorry, but until someone cleans up the spam mess, that's the
way it has to be.

E-Mails, die direkt an diese Adresse geschickt werden, lese und
beantworte ich nicht. Ich bedauere diesen Umstand sehr, kenne derzeit
aber keine bessere Möglichkeit, um die Spam-Flut abzustellen.

Mit freundlichen Grüßen / Best Regards
Michael Gast
SEPP MED GmbH