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