sql-ledger-users

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

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

Re: [SL] Corrupting Access

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

ok. I fixed it. here is the background.

see http://archives.postgresql.org/pgsql-novice/2001-01/msg00290.php for 
changing the Owner of a table.

here is the transcript of the sql:

=# select usesysid from pg_user where usename = 'sql-ledger';
=# select usesysid from pg_user where usename = 'lane';

with the above integer values:
=# update pg_class set relowner=101 where relowner=103;
uniformly assigns the ID of sql-ledger to all of your tables.

Lane

Lane Sharman wrote:

>                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

Re: [SL] Corrupting Access

[nefsoft <in...@ne...>]

Lane,

i'll advice to use the owner of the database self as owner of the tables:
on my box i've :

CREATE DATABASE prod
  WITH OWNER =3D "sql-ledger"
       ENCODING =3D 'LATIN9'
       TABLESPACE =3D pg_default;

you can see that in pgadmin3 by clicking on the db name that you want.

for the users, i've only these 2:
CREATE USER postgres
  WITH SYSID 1
  ENCRYPTED PASSWORD 'md52f001c210c241d8ec746617694853b43'
  CREATEDB CREATEUSER;
CREATE USER "sql-ledger"
  WITH SYSID 100
  ENCRYPTED PASSWORD 'md54392a91bc26740bbaeff738cc34c2735'
  CREATEDB CREATEUSER;

in your case i think that lane is not an user database. if yes, u can make
it owner of the db and owner of all tables, restart the db and should works
too.

good luck
kasem

2006/11/27, Lane Sharman <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 =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
> >without explicit disconnect.
> >
> >
> >
>
>
> --
> 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=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>


--=20
Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es / Freundlic=
he
Gr=FC=DFe !!!
NEFSOFT
St. Truidensesteeweg, 263
3300 Tienen (Belgium)
Tel : +32 16 78 09 38
Fax : +32 16 82 04 58
GSM : +32 495 25 12 33
Email : in...@ne...
www.nefsoft.com