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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Database History

Re: Database History

From: Lieut_Data <lIeuT_dAtaREMOVEME_at_yahOO.com>
Date: Wed, 12 Mar 2003 13:12:00 -0500
Message-ID: <b4nss501lgg@enews2.newsguy.com>


> > Or should I not delete users/hardware at all? Just mark them
> > "inactive", preventing them from showing up in the main list, where
> > they are not used. But what if we want to use a username again, for
> > a new employee?
>
> I'm currently working on a system that has the exact need that you
> mention. What I've done to solve this is to add an 'is_active' flag
> to the rows that need to be preserved.

Exactly! That makes very good sense: Thank you!!

Lieut_Data Received on Wed Mar 12 2003 - 12:12:00 CST

Original text of this message

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