From: Lane S. <la...@op...> - 2006-11-27 04:38:24
|
I have corrupted access to my most important data set. Call it A. And call the user lane. Basically, in admin mode, I set up dataset B and saved the user as lane. That was a big mistake. Now I cannot get into dataset A under any user: DBD::Pg::st execute failed: ERROR: permission denied for relation customer at SL/Form.pm line 1823. Error! SELECT ct.name AS customer, a.curr AS currency, a.customer_id, current_date + ct.terms AS duedate, a.department_id, d.description AS department, ct.notes, ct.curr AS currency FROM ar a JOIN customer ct ON (a.customer_id = ct.id) LEFT JOIN department d ON (a.department_id = d.id) WHERE a.id = 10452 ERROR: permission denied for relation customerDatabase handle destroyed without explicit disconnect. -- Kindest Regards, Lane Sharman 858-755-2868 |