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
|
