Re: Missing GRANT on 'exchangerate' table

[Chris Travers <..hidden..>]

On Tue, Dec 13, 2011 at 2:49 PM, Erik Huelsmann <..hidden..> wrote:
> Part of the problem with the exchange rates has been solved: one of
> the errors we were seeing was caused by a missing GRANT.
>
> Currently, the Roles.sql file grants only SELECT rights to public,
> which is probably correct. However, none of the modules grant
> UPDATE/INSERT rights.
>
> I fixed our access problems by granting INSERT and UPDATE to lsmb_<?
> company ?>__ap_transaction_create and lsmb_<? company
> ?>__ar_transaction_create.
>
> Should I commit that change to our Roles file? Or did I forget any
> roles to allow this to?

My suggestion would be to create another role at the top for setting
exchange rates and then add that role to the ones you mention and
sales_order_create, purchase_order_create, sales_quotation_create and
rfq_create.

If we need to break it off in the future then it becomes easy to do so.

Best Wishes,
Chris Travers

>
>
> Bye,
>
> Erik.
>
> ------------------------------------------------------------------------------
> Systems Optimization Self Assessment
> Improve efficiency and utilization of IT resources. Drive out cost and
> improve service delivery. Take 5 minutes to use this Systems Optimization
> Self Assessment. http://www.accelacomm.com/jaw/sdnl/114/51450054/
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel