[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Missing GRANT on 'exchangerate' table
- Subject: Re: Missing GRANT on 'exchangerate' table
- From: Chris Travers <..hidden..>
- Date: Wed, 14 Dec 2011 17:38:01 -0800
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
>>> 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
>> If we need to break it off in the future then it becomes easy to do so.
> 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