[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Permission error updating chart of accounts
- Subject: Permission error updating chart of accounts
- From: Leah Kubik <..hidden..>
- Date: Tue, 1 May 2007 17:14:29 -0400
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