Permissions problems

From: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
To: pgsql-general(at)postgreSQL(dot)org, pgsql-hackers(at)postgreSQL(dot)org
Subject: Permissions problems
Date: 1999-03-06 02:28:16
Message-ID: 93C04F1F5173D211A27900105AA8FCFC145248@lambic.prevuenet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

I know, it sounds like a personal problem. Well it is but I am hoping
someone cant point in the right direction. I am trying to get a handle on
the whole security thing.

select * from status;
NOTICE: in_group: group 4 not found
ERROR: status: Permission denied.

Does anyone know what this means? Here is how to duplicate the problem:

Add group 4:

INSERT INTO pg_group VALUES ('dba', 4);

Create a user in that group

CREATE USER "Admin" IN GROUP dba;

Grant permissions on group dba:

GRANT ALL ON status to GROUP dba;

Log into psql as Admin and select * from status. You should get the error
above. Any ideas what I am doing wrong. I am running PostgreSQL 6.4.2 on
Red Hat 5.1. Access97 does not want to all me write access to any of my
tables. Once I install any kind of permissions (using grant), it would let
me even open the tables.

Browse pgsql-general by date

  From Date Subject
Next Message Martin Möderndorfer 1999-03-06 08:41:50 ER, OMT chart of a database
Previous Message Michael Davis 1999-03-06 01:54:13 View causes error in pg_tables

Browse pgsql-hackers by date

  From Date Subject
Next Message Gerald L. Gay 1999-03-06 03:44:05 Re: [HACKERS] for row in select loop question
Previous Message Michael Davis 1999-03-06 01:54:13 View causes error in pg_tables