|
From: Marvin D. <pe...@be...> - 2002-01-01 21:25:02
|
Hi David, If I am not mistaken, you can setup sql-ledger to force users to reverse entries (As opposed to the ability to delete entries) by issuing a REVOKE DELETE rights statement for users: GRANT SELECT, INSERT, UPDATE, DELETE ON <all the SQL-Ledger tables> TO username REVOKE DELETE ON acc_trans FROM username Take it easy. PS: I didn't know you were on this list.... On Tuesday 01 January 2002 10:29, you wrote: > Apart from adding "me too" (Tm AOLusers), I'd like to add that the only > "problem" I see with using SQL-Ledger, at least for US businesses, is that > you can delete transactions. I don't know about Canada, but at least in > the US, GAAP (Generally Accepted Accounting Practice) is (or at least was) > that you don't delete transactions, you create reversing entries. > > Ciao, > > David A. Bandel |