Re: [SL] Corrupting Access

[Nefnifi, K. <Kas...@at...>]

Hi Lane,=20

Logon into your db as DBA using pgadmin3 (use may be sql-ledger or
postgres user),
Grant permissions to the user lane.
So the problem should be solved.
Kasem,


-----Original Message-----
From: Lane Sharman [mailto:la...@op...]=20
Sent: maandag 27 november 2006 5:35
To: sql...@sq...
Subject: [SL] Corrupting Access

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 =3D ct.id)
LEFT JOIN department d ON (a.department_id =3D d.id)
WHERE a.id =3D 10452
ERROR: permission denied for relation customerDatabase handle destroyed=20
without explicit disconnect.

--=20
Kindest Regards,

Lane Sharman
858-755-2868

------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users