If you are using SQL Grant/Revoke, you can deny delete on any table for all but the owner. If not, you can certainly add it to your system. Razzak’s ate web site has a comprehensive article on the use of Grant/Revoke to prevent troubles with your data.
Albert > On Feb 8, 2018, at 10:15 AM, Buddy Walker <walker.bu...@comcast.net> wrote: > > Dick > Have you re-loaded/packed the database recently. I would suggest pack keys > for the table in question. It could be the index is corrupt and the row is > not really deleted. > > If the row is actually deleted I would suggest putting an On Before DELETE > trigger on the table. This way you could get the row information and insert > into tblDeletions and add username to that row. This way you will know who > is doing the deletions. > > Buddy > > > -----Original Message----- > From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of > Carpet Broker, Dick Fey > Sent: Thursday, February 8, 2018 10:46 AM > To: RBase Maillist <RBASE-L@GoogleGroups.com> > Subject: [RBASE-L] - Lost rows > > Help... > > We are having a problem with occasional rows just disappearing from a table. > We know they were there in the beginning, because we print an order when > entered. > > Sometimes coming back to the order later, 1 or more detail rows are missing. > I have no idea how that can happen. > > The question is.... Can I make it impossible for rows to be deleted from a > table under any circumstances ? > > Found a rule restricting deletion, but not absolute. Any ideas would be > helpful. > > Thanks, > > Dick Fey > > -- > Carpet Broker Inc > P: 913-894-9211 > F: 913-894-0138 > > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rbase-l+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rbase-l+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
