Re: Permission error updating chart of accounts

[Leah Kubik <..hidden..>]

On Tuesday 01 May 2007 17:40, Chris Travers wrote:
> Normally when this happens, the id sequence is listed in the error.
>
> Iirc, PostgreSQL bypasses certain permissions check for superusers,
> but not just based on ownership.  So it is entirely possible that the
> ledgersmb owner does not have appropriate permissions to the table.
>
> Hence:
> grant all on chart to ledgersmb;

Ok, so even though ledgersmb was the owner, it turned you you were correct, 
the admin privs weren't set...  I've gotten past that and now I'm getting an 
error with the relation 'chart'

How do I correct the permissions for a relation?  I've got the sequences and 
tables square.

frauerpower-accounts(# \z chart
 Access privileges for database "frauerpower-accounts"
 Schema | Name  | Type  |       Access privileges
--------+-------+-------+-------------------------------
 public | chart | table | {ledgersmb=arwdRxt/ledgersmb}
(1 row)

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

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