Subject Re: [ib-support] previleges according to date
Author Milan Babuskov
----- Original Message -----
From: <irel_llc@...>
To: <>
Sent: Saturday, December 28, 2002 12:23
Subject: [ib-support] previleges according to date

> These SPs will check the field date value against the current date.
> However I see a big security hole: normal users could change the PC
> date and modify whatever row they want.
> Is there any better solution ?

Maybe if you compare against the max_date entered, i.e.

instead of: if ( > current_timestamp)
use: if ( > (select max(date_field) from table).


Milan Babuskov

P.S. I totally agree with Doug's answer anyway.