Re: Permission error updating chart of accounts

["Chris Travers" <..hidden..>]

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