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

Permission error updating chart of accounts



I'm running LedgerSMB 1.2.2.  I'm having trouble with one of my datasets if I 
try to update or create something in the chart of accounts:

DBD::Pg::st execute failed: ERROR: permission denied for relation chart
Error!

INSERT INTO chart
(accno, description, charttype,
gifi_accno, category, link, contra)
VALUES (?, ?, ?, ?, ?, ?, ?)
ERROR: permission denied for relation chart

I'm guessing this is some kind of ownership / grant problem in the database, I 
don't have the issue with another dataset, but everything looks correct.  
Does anyone know what I  should check here?  I'm happy to provide any data 
needed.  This was migrated from sql-ledger, and the database user was updated 
to 'ledgersmb', but perhaps something was missed?

The user for the application is running as 'ledgersmb' and that user is the 
owner of the chart table.

Leah
-- 
Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511
Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada
MSN: ..hidden.. | AIM: frauerpower | Yahoo: h3inous
F9B6 FEFE 080B 8299 D7EA  1270 005C EC73 47C9 B7A6