Re: Missing GRANT on 'exchangerate' table

[Chris Travers <..hidden..>]

On Wed, Dec 14, 2011 at 12:17 PM, Erik Huelsmann <..hidden..> wrote:
>>> 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.
>
> r4205
>
> If I'm correct, this doesn't need a specific correction in Fixes.sql. True?

Yes, we'd need to issue the GRANT role statements in Fixes.sql

Best Wishes,
Chris Travers