Re: Permission error updating chart of accounts

[Leah Kubik <..hidden..>]

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

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