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

Re: Permission error updating chart of accounts

Did you check permission for any of the sequences that may be attached to the chart table? The only reason I ask is that I ran into a situation recently where sequence permissions got changed and the error seemed to point at table permissions as the culprit. 

Charley

Leah Kubik wrote:

On Tuesday 01 May 2007 17:21, Chris Travers wrote:

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


The table is owned by the 'ledgersmb' user... So that's why I'm stumped...


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

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

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