[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Missing GRANT on 'exchangerate' table

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