Re: Permissions problem on 7.4 - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Permissions problem on 7.4
Date
Msg-id Pine.LNX.4.44.0312012147070.23890-100000@peter.localdomain
Whole thread Raw
In response to Permissions problem on 7.4  (Michalis Kabrianis <mk@interzone.gr>)
List 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@gmx.net



pgsql-sql by date:

Previous
From: Michalis Kabrianis
Date:
Subject: Permissions problem on 7.4
Next
From: "zerobearing2"
Date:
Subject: XML & Postgres Functions