Re: Permissions problem on 7.4

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Michalis Kabrianis <mk(at)interzone(dot)gr>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Permissions problem on 7.4
Date: 2003-12-01 20:48:00
Message-ID: Pine.LNX.4.44.0312012147070.23890-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Michalis Kabrianis writes:

> Schema | Table | Access
> privileges
> ---------+---------+-------------------------------------------------------------------------------------------------
> cust | clients | {admin=a*r*w*d*R*x*t*/cust,"group salesmen=r/cust"}
>
>
> The problem is that when I check from within my application if a member
> of the group salesmen has permissions to INSERT into the group clients,
> I get an affirmative question.

Fix your application.

> I guessed it was a problem with my application, so I downloaded
> postgresql_autodoc (http://www.rbt.ca/autodoc/) in order to check the
> permissions better.
> It also claims that group salesmen has the right to SELECT, INSERT and
> DELETE on table clients.

Report a bug to the authors of that program.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message zerobearing2 2003-12-01 22:17:22 XML & Postgres Functions
Previous Message Tomasz Myrta 2003-12-01 20:01:05 Re: Concatenating multiple fetches into a single string