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

Error Posting Purchase Order

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?

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.
Ledger-smb-users mailing list