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

Re: Permission error updating chart of accounts

Hi Leah;

Check the owner of the table.  It may be owned by Postgres while the
user is ledgersmb.

Best Wishes,
Chris Travers

On 5/1/07, Leah Kubik <..hidden..> wrote:
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

(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 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

This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
Ledger-smb-users mailing list