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

Re: Error Posting Purchase Order



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
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users