Re: [firebird-support] Protecting data from end users

2012-01-16 Thread Mark Rotteveel
On Sun, 15 Jan 2012 20:37:37 -, richwiz11 richard.cro...@wizbang.co.nz wrote: Hi, I need a way of logging or protecting data from being deleted by a user. I work for a POS (point of sale) company, each user shop would have a local firebird db running. We are entering into a new market

[firebird-support] Protecting data from end users

2012-01-15 Thread richwiz11
Hi, I need a way of logging or protecting data from being deleted by a user. I work for a POS (point of sale) company, each user shop would have a local firebird db running. We are entering into a new market where regulation states we have to protect our system from tax evasion (where possible)

Re: [firebird-support] Protecting data from end users

2012-01-15 Thread Michael Ludwig
richwiz11 schrieb am 15.01.2012 um 20:37 (-): The problem I am left with is how to protect a row from being deleted. The two method I have thought of is a) Using roles and remove the delete privilege (we currently just using SYSDBA, which is probably a bit bad anyway) or b) Add some

Re: [firebird-support] Protecting data from end users

2012-01-15 Thread Helen Borrie
At 09:37 AM 16/01/2012, richwiz11 wrote: Hi, I need a way of logging or protecting data from being deleted by a user. I work for a POS (point of sale) company, each user shop would have a local firebird db running. We are entering into a new market where regulation states we have to protect our

Re: [firebird-support] Protecting data from end users

2012-01-15 Thread Alexey Kovyazin
Hello Richard, We have figured out to how protect sales data from being altered. The problem I am left with is how to protect a row from being deleted. (firstly, have come to the conclusion that it impossible to fully protect data, however the idea here is just make it a bit harder and