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

Re: Missing GRANT on 'exchangerate' table



After our discussion through gTalk, I converted these to GRANTs in
Roles.sql. r4220.

Bye,

Erik.

On Thu, Dec 15, 2011 at 2:38 AM, Chris Travers <..hidden..> wrote:
> 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
>
> ------------------------------------------------------------------------------
> 10 Tips for Better Server Consolidation
> Server virtualization is being driven by many needs.
> But none more important than the need to reduce IT complexity
> while improving strategic productivity.  Learn More!
> http://www.accelacomm.com/jaw/sdnl/114/51507609/
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel