I have a customer who centrally manages their item file and replicates it out a night. The local users should not have the ability to insert or modify the item file. However, they require the ability to run the cost adjustments batch job and the the ability to add planning criteria both of which require rights to the item table. I was thinking of trying to implement at least some of this through code; seeing as I can tell wether to database is local or head office is there any way through code of
- cancelling an insert if the database is local.
- allowing updates to certain fields.