Re: Error Posting Purchase Order

Subject: Re: Error Posting Purchase Order

From: Chris Travers <..hidden..>

Date: Tue, 30 Jul 2013 23:58:53 -0700

I am looking into this. I expect a fix to be committed shortly.

For now you can grant the permissions on that table directly to your user. After 1.3.34, this will be fixed for all users with apprpriate permissions.

Best Wishes,

Chris Travers

On Tue, Jul 30, 2013 at 5:37 AM, M Lubratt <..hidden..> wrote:

Good morning!

I'm using LSMB 1.3.33 and my user has all permissions enabled. When I press "Post As Shown" on a Purchase Order, I get an error basically saying that I don't have permission to "DELETE FROM ACC_TRANS". I checked the table and nothing has permission to delete except the user postgres. I did a quick grep scan of the LSMB source and found numerous instances of "DELETE FROM ACC_TRANS".

Is this an oversight in the permission code? Should I just give myself permission?

Thanks!
Mark

------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

http://www.efficito.com/learn_more.shtml

------------------------------------------------------------------------------ Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk