Re: [SL] Corrupting Access

[Lane S. <la...@op...>]

                List of relations
 Schema |      Name      |   Type   |   Owner   
--------+----------------+----------+------------
 public | acc_trans      | table    | sql-ledger
 public | ap             | table    | sql-ledger
 public | ar             | table    | sql-ledger
 public | assembly       | table    | sql-ledger
 public | audittrail     | table    | lane
 public | business       | table    | lane


shows that my ownership is partially corrupted. Normally, all datatbase 
tables are owned by sql-ledger. So, I will change the owner to 
sql-ledger? Please advise.

thanks, Kasem.

Lane

Nefnifi, Kasem wrote:

>Hi Lane, 
>
>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...] 
>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 = 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