permissions problem

From: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
To: "'pgsql-hackers(at)postgreSQL(dot)org'" <pgsql-hackers(at)postgreSQL(dot)org>, pgsql-general(at)postgreSQL(dot)org
Subject: permissions problem
Date: 1999-03-05 23:14:35
Message-ID: 93C04F1F5173D211A27900105AA8FCFC145243@lambic.prevuenet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

I create a group:

INSERT INTO pg_group VALUES ('dba');

I create the following user:

CREATE USER admin IN GROUP dba;

Next:

grant all on table_name to GROUP dba;
select * from pg_class where relname = 'table_name';

Psql aborts with the following error:

ERROR: parser: parse error at or near ";"
mp=> select * From pg_class where relname = 'status';;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally before
or while processing the request.
We have lost the connection to the backend, so further processing is
impossible. Terminating.

Any ideas on what could be causing this and/or how to work around it? I am
running 6.4.2 on linux Red Hat 5.1.

Thanks, Michael

Browse pgsql-general by date

  From Date Subject
Next Message Michael Davis 1999-03-06 01:05:33 RE: [GENERAL] permissions problem
Previous Message Dan Sawyer 1999-03-05 20:14:41 mpsql question ??

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-03-05 23:24:41 Re: [HACKERS] Why is that so slow?
Previous Message The Hermit Hacker 1999-03-05 20:15:25 Re: [HACKERS] Stupid CVS question